How to set up query to search for values in an array

[gunishi]

Hi all, 

I have an array of asset tags, and I want to check in the cmdb_ci_server table to see if they are there. 

I want to make it so that the function returns false if even one of the values in the array is not in the cmbd_ci_server. 

I know I could do this as:

gr.addQuery('Asset Tag', assetTags[0]); 

gr.addQuery('Asset Tag', assetTags[1]);

and so on, but I was wondering if there is a way for me to query the whole array?

Thank you for all your help!

G

[VishalB06557037 · Accepted solution]

Hi @gunishi 

You can convert array into String.

Then add encoded query 

E.g., var array =[A100,B100]

var arrayStr = array.toString()

gr.addEncodedQuery("asset_tagIN" + arrayStr);

if (gr.next()){

//Record present

} else {

//Not present

}

[gunishi]

Hi @VishalB06557037 

Thank you so much for the swift response.

This has helped me no end! Just to confirm, will this search for each asset tag in the aray individually?

G

[VishalB06557037]

Hi @gunishi 

For this you can use for loop instead of if.

E.g.,

var result = false;

var array =[A100,B100]

var arrayStr = array.toString();

gr.addEncodedQuery("asset_tagIN" + arrayStr);

while (gr.next()){

result = true;

} 

[gunishi]

Hi @VishalB06557037 

This is very helpful, thank you so much. 

G