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]

Sorry..

below is the code..

approval.addQuery('wf_activity.name','IN','Level 2 Group Approval,Ontrack Internal P4DTG L2 approver');

[sushant007]

this query looks good to me; can you please check on if there are really record present for these 2 activities?

if yes; then I would suggest to do following:

1. Open sysapproval_approver table

2. in first filer select "wf_activity.name" and operator "IS ONE OF" and values " Level 2 Group Approval And Ontrack Internal P4DTG L2 approver"

3. Run the filter

if this gives to expected result then

right click on bread crumb and copy query

and finally your new query will be like following:

approval.addEncodedQuery('<Paste the copied query here>');

give a try and let me know if it helps.

[Community Alums]

wf_activity.nameINLevel 2 Group Approval,Ontrack Internal P4DTG L2 approver

this is the result i got..

Will check with this and update u..

Thank u so much Sushanth

[sushant007]

approval.addEncodedQuery('wf_activity.nameINLevel 2 Group Approval,Ontrack Internal P4DTG L2 approver');

this should be your query then

[Community Alums]

Thank u so much Sushant,

I didnt know this method..

I think @ Paul Morris also telling me.. that time i didnt understand..

Thank u all..

Regards,

Roopa