Syntax for addquery(' ' , 'IN', ' a, b')

Community Alums
Not applicable

Hi all,

Could u help me with correct syntax for addquery(' ' , 'IN', ' a, b')

Acually i want to query like if the wf activity is L1 approver or Wf activity is L2 approver.

I tried below but not working ..

approval.addQuery('wf_activity','IN','Level2GroupApproval,OntrackInternalP4DTGL2approver');

Regards,

Roopa

21 REPLIES 21

The SN Nerd
Giga Sage
Giga Sage

If you are stuck on query syntax, try to build it in the Condition Builder first.



When you're happy with the results, right click on the breadcrumb and click 'Copy query'.



On a side note, the wf_activity field on the sysapproval_approver table is inactive.



Regards,


Paul



ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022

Community Alums
Not applicable

Thank u so much for all , helped to achieve it



Regards,


Roopa