im doing something wrong.....because that give me the deals from the first condition (COMPANIES.company_id,157,18,498) but not from the second part (DEALS.is_tourism=1) and the search bar look for "or" text criteria....
What do you mean with "..the search bar look for "or" text criteria..."
Just to clarify, I am not talking about the search object (well, haven't tried with that), I am talking about the search field that you get when clicking on the caption of the list box and start typing or by clicking on the magnifying glass.
Then you maybe need to clear the field from wildcards * and enter the complete line exactely as given here:
=match(COMPANIES.company_id,157,18,498) or DEALS.is_tourism=1
Sure, but since we started with a reference thread that involved too much complexity, we need to check what is the right level of complexity.
You could for example create a variable with an input box for the companies id, and create a button with action select in field for field deals and an appropriate search string. If I find time, I will post a proposal.
