Search jQuery

jQuery Forum

Getting Started

gautamx07

How to select id's of multiple products using VQL?

in Getting Started • 4 years ago

Apologies for the slightly irrelevant question but ...

I currently have the following query to select the id of a single product, like so:

client.post(https://merck-nextgen.veevavault.com/api/v18.3/query?q=SELECT id FROM product__v WHERE name__v = '${VOLT_CREDENTIALS.get('cred').productName }'` , args , function( data , res) {
//console.log( 'PRODUCT ID IS ' + data.data[0].id);
productID = data.data[0].id;
resolve("Product ID Retrived ...");
});

But what if i have multiple products , I.E. maybe more then one , how do i go ahead and select the id's of multiple products using the same query as above ?

I am using nodejs and VQL.

Right now the value of VOLT_CREDENTIALS.get('cred').productName is just "demoproduct". So how do i go about selecting the id's of multiple products ?

Replies(5)

kbwood.au

Re: How to select id's of multiple products using VQL?

4 years ago

The SQL would be:

... WHERE name__v IN ('id1', 'id2', ...)

What is VOLT_CREDENTIALS? It doesn't look like a jQuery object.

watusiware

Re: How to select id's of multiple products using VQL?

4 years ago

For VQL questions, ask the publisher of VQL, or read the documentation.

The documentation says it is a "SQL-like" language.

Popular databases don't even follow current standards exactly. Let alone a "SQL-like" language.

And passing a SQL query in a POST from a browser is completely insecure.

IN() is just a shortcut way of writing a string or ORs.

Just took a look, and VQL does not support the standard IN(). It uses it's own invention, CONTAINS().

https://developer.veevavault.com/vql/#using-comparison-operators

Don't make the assumption that non-standard languages follow standards.

I'm aghast if a drug company has an API that lets you query a database from a browser using a "SQL-like" language. I'm sure they meant it to be used from a server program, not from a browser!

Even so, if you write a server program, use bound variables, rather than constructing a SQL statement by pasting-in values. It is NOT secure from hacking by constructing clever values! Any C-grade hacker can figure this out.

gautamx07

Re: How to select id's of multiple products using VQL?

4 years ago

Tried this

client.post(https://merck-nextgen.veevavault.com/api/v18.3/query?q=SELECT id FROM product__v WHERE name__v IN ( '${product_name[0]}' , '${product_name[0]}' )` , args , function( data , res) {
//console.log( 'PRODUCT ID IS ' + data.data[0].id);
//productID = data.data[0].id;
console.log(data);
resolve("Product ID Retrived ...");
});

But i get an error :

{ responseStatus: 'FAILURE',
errors:
[ { type: 'INCORRECT_QUERY_SYNTAX',
message: 'Cannot parse the search phrase [SELECT id FROM product__v WHERE name__v IN ( \'AU ANDRIOL\' )]: Unknown token [\'AU ANDRIOL\'] found near position [45] at
line [1]' } ] }

VOLT_CREDENTIALS is just a javascript Map that i create

watusiware

Re: How to select id's of multiple products using VQL?

4 years ago

Oh! You are using nodejs! That's a server program.

Use bound variables, don't paste values you get from the browser into a SQL statement! Don't try to "sanitize" values, it's just a good place for errors to creep in.

watusiware