Having some issues with the criteria of a BAQ. I’m trying to create a more robust customer search feature for Customers, and I want the BAQ to have 3 criteria.
The first is one that is a yes/no that is IncludeInactiveCustomers, if you select it, it includes active and inactive. If it is unchecked, it only pulls active.
The second is a search bar that uses a contains or matches, or some function that allows us to search by customerID
The third is the same as the second, but for customer name.
I have included below a picture of an example of the criteria, and this works when it’s the only criteria, but when I add the second, which is a copy of this for customername, it stops working. SQL error but Syntax is okay.
CONTAINS is for full-index searches, use LIKE as suggested
CONTAINS is a predicate used in the WHERE clause of a Transact-SQL SELECT statement to perform SQL Server full-text search on full-text indexed columns containing character-based data types.
This is what my criteria looks like, both parameters have the Skip Condition if Empty clause checked, but when I run it with some information entered in one of the parameters, it doesn’t give me the information. The same goes if i put accurate information in both parameters
But instead of a SQL error, it says no records returned
