Join two Encoded queries by OR condition

[Raji10]

Hi All,

I am trying to combine two Encoded queries with an Or condition, example:

query 1 = 'element_id=' + converseRecord + '^valueLIKEhow^valueLIKEhelp';

query 2 ='element_id=' + converseRecord + '^valueLIKEwhat^valueLIKEissue';

gr1.addEncodedQuery(query1) || addEncodedQuery(query2);

Can anyone help how the above logic can be achieved in GlideRecord. Thank you

Thanks & Regards,

Rajalakshmi.

[Adrian Ubeda · Accepted solution]

Hi, 

use ^NQ operator between queries. This will evaluate one query and the other and will be like query 1 + OR + query 2. The syntax's like follows:

gr1.addEncodedQuery('element_id=' + converseRecord + '^valueLIKEhow^valueLIKEhelp^NQ' + 'element_id=' + converseRecord + '^valueLIKEwhat^valueLIKEissue');

If it was helpful, give positive feedback.
Thanks, 

[Prateek kumar]

Please take a look at below:

https://community.servicenow.com/community?id=community_question&sys_id=def3bcc6db6513042d1efb651f96...

[Santosh_Ksagar]

Hi Raji,

If you could run a filter on this table then you can add the encoded query as below:-

1) Add the filter as per your requirement:-

2) copy the query after you run this filter

3) You can add this encoded query in your script like this:-

var gr = new GlideRecord('tablename');

gr.addEncodedQuery('active=true^stateIN2,3^priority=3');

gr.query();

if(gr.next()){

}

Thanks
Santosh

[Hemant Goldar]

Hi Raji,

Same thread has been solved before follow the link

https://community.servicenow.com/community?id=community_question&sys_id=def3bcc6db6513042d1efb651f96...

Please mark helpful/correct based on impact.

Kind Regards,

Hemant