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

[Community Alums]

Hi Roopa,

Try this

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

If this is not working. Can you explain on which table you are trying to run the query.

[paulmorris]

Just leave a space is fine.

[Community Alums]

Hi..

Spaces not working

Regards,

Roopa

[sushant007]

share your query

[Community Alums]

approval.addQuery('wf_activity.name','IN','Level_2_Group_Approval,Ontrack_Internal_P4DTG_L2_approver');