How we can query the Account based on Two parameter as OR Condition.

[former_member551200]

Hello Experts,

I want to search/query for Account based on selection filter "Customer Portal Group" OR "Customer Portal Type" both as OR Condition, because you know that advanced search filter query the record based on AND Condition. So here my requirement is that , search the data using "Customer Portal type" OR "Customer Portal Group" using both parameter as OR condition.Means if we set the both parameter, but "Customer Portal Group" is blank then it should only display the Customer Portal type related Data.

[dominik_filip]

Hi Sanjay,
there is no option for OR operator in queries (as is not in old CRM) but I think there is one workaround possible:
1. In Advanced search click on "plus" next to your fields:

2. Add values you need and include "is initial" in both fields:

This way you'll get the same results as with OR operator.

Regards,
Dominik

[former_member551200]

Hi Dominik,

Thanks a lot.

[former_member551200]

Yes these are two different fields like dropdown.

[nikhilwalsetwar]

Hi Sanjay,

Are these two diff fields? or same fields different values like dropdown?

Nikhil