Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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

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