Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to add query in existing query in service portal

Patiljuned
Tera Contributor

I have below query available in portal simple list filter.

active=true^EQ^ORDERBYDESCsys_updated_on

Now i want to add the below mentioned logical context in existing query.

"AND" contact_type "IN" current.account.u_case_view_restriction

 

for getting some results.

 

Appreciate the responses.

3 REPLIES 3

Community Alums
Not applicable

You'll need to include it using the ^ syntax for query building. Here's the modified query:

contact_typeINcurrent.account.u_case_view_restriction^active=true^EQ^ORDERBYDESCsys_updated_on

 

If you found this helpful, a 'like' is the secret handshake of appreciation!

-Prasad 

Patiljuned
Tera Contributor

Thank you Prasad, i have tried but not working.

Anand Kumar P
Giga Patron

Hi @Patiljuned ,

active=true^EQ^ORDERBYDESCsys_updated_on^AND^contact_typeINcurrent.account.u_case_view_restriction

Thanks,

Anand