Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is it possible to do an advance search on multiple fields with "OR" operator?
e.g: I have a Search object that has fields like Region, Country , State, City as searchable fields
I want to do a search like
Region = 'Europe' OR Country = 'Canada' OR City = 'Tokyo'
so that I don't need to check them individually if I am interested in the Sales of those areas.
Is it possible to do a search like this without altering anything at the script level? It's ok even if I can create a bookmark to achieve this.
Thank you in advance,
Bhaskar
Like this?
You can write a search string like
=Region='Europe' or Country='Canada'
directly in a list box. It is a valid search string. Note the initial equal sign.
The problem is that you use unaggregated field references in it. Which means that it will not always work. It will work if there is only one possible Region or Country - e.g. if you search in a City field. But it will not work if you make the search in a field that can have several Regions/Countries per entry, e.g. Company.
HIC