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

[Community Alums]

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

[surya4541]

You can pass in array

var approvaluser= [];

approvaluser.push(''+grUsers.approver);

approval.addQuery('wf_activity','IN',approvaluser);

[sushant007]

Hi Roopa,

which table you are querying on? Please help me with it

[sushant007]

try replacing following:

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

with

approval.addEncodedQuery('wf_activity.nameINLevel2GroupApproval,OntrackInternalP4DTGL2approver');

or

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

Note: Above line is considering you selected correct wf_activity name eg.Level2GroupApproval or OntrackInternalP4DTGL2approver

[Community Alums]

Hi Sushanth,

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

thisworked for me...

Thank u so much.

if there are spaces like ' Level 2 Group Approval'

How to do it..

Yes querying "sysapproval_approver" table

Regards,

Roopa