How do we fixed multiple filter over the list view like All > Approver Id = javascript:gs.getUserID() > status=Pending for Approval

Pradeep Sharma2
Kilo Explorer

Hi

How can we fixed multiple filter query over the list like (All > Approver Id = javascript:gs.getUserID() > status=Pending for Approval ), I tried 

&sysparm_fixed_query=approver_id=javascript:gs.getUserID()&sysparm_fixed_query=status=Pending for Approval

but its not working for multiple condition.

actually we do not want to show all the record to Approver which are approved we only want to show pending for approval record.

I also tried before query Business Rule with check of this code, debugger not going inside if condition.

if (current.aprrover_id == gs.getUserID()) {
 
    current.addQuery('approver_id', gs.getUserID()).addCondition('status', 'Pending for Approval');
   
    }
 
 
 
 
Please suggest
 
Thanks and Regards
Pradeep Sharma

 

5 REPLIES 5

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

like this

give correct choice value for Pending for Approval

&sysparm_fixed_query=approver_id=javascript:gs.getUserID()^status=Pending for Approval

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Pradeep Sharma 

Hope you are doing good.

Did my reply answer your question?

If my response helped please close the thread by marking appropriate response as correct so that it benefits future readers.

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi Ankur, 

 

Thank you very much, its working for me.

 

Thanks and Regard,

Pradeep Sharma

@pradeep

not sure if you have another account from where you posted this question.

@Pradeep Sharma 

Please mark my response as correct and close the thread.

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader