How to select id's of multiple products using VQL?
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 ?