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
Tera Patron

Hi @Patiljuned ,

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

Thanks,

Anand