OnDemand User Group

Support Forums => Report Indexing => Topic started by: J9CMOD on December 03, 2014, 10:56:26 AM

Title: How can I use AND in addition to OR operators in same search criteria
Post by: J9CMOD on December 03, 2014, 10:56:26 AM
I haven't been able to find anything in on-line help or the books on this.
We have reports that we want the customer to be able to search using the AND operator in addition to the OR operator for different fields.  Does anybody know how I can set this up? 

Example:
Indexes:
Customer
Reason
Message

and I'd like to be able to say (in sql terms)  Customer = abc AND (Reason like %error% OR Message like %invalid%)

I know I can create a "canned" query for the customer to use for any search where the search values will remain the same, but would like to allow them to make the correct "choices" on their own.