Syntax for addquery(' ' , 'IN', ' a, b')
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-30-2017 01:08 AM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-30-2017 01:40 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-30-2017 10:18 PM
Thank u so much for all , helped to achieve it
Regards,
Roopa