Join two Encoded queries by OR condition

Raji10 · ‎03-30-2020

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 · ‎03-30-2020

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,

If it was helpful, please give positive feedback! ✔
☆ Community Rising Star 22, 23 & 24 ☆

View solution in original post

Deepak Ramar1 · ‎06-14-2022

Hi Rajalakshmi,

Fix for incorrect reference links while using (^NQ) operator : https://community.servicenow.com/community?id=view_idea&sysparm_idea_id=26aaaafddb4011d45205e6be1396...

Solution : Whenever we use ^NQ operator to join multiple queries to build a master query

we need enter ^current.getEncodedQuery() at every (^NQ) operator JOINs before moving to final encoded query

Example :

Levelcheck1 : hr_service.u_service_entity=3ef7cbc287e68d900d9f7447cebb359d

Levelcheck2 : hr_service.u_service_entity=0e974b8287e68d900d9f7447cebb35e2^assignment_group=fe7be44b8751b0100d9f7447cebb3515

Levelcheck3 : number=HRC0052382^ORnumber=HRC0001703

Mergedquery1 = Levelcheck1+^NQLevelcheck2+ "^" + current.getEncodedQuery();
Mergedquery2 = Mergedquery1+^NQLevelcheck2+ "^" + current.getEncodedQuery();

current.addEncodedQuery(Mergedquery2)

Regards,
Deepak R