i need to pull sales data for 8 different customer names. i need to do a keyword search because of how we set up some of the CustIDs.
how do i set up the BAQ so i can type in 8 different keywords and it find CustName value similar to that.
is the search the same field? or 8 unique fields as well?
basically i need to find 8 different customers (could be more based on how we set up CustID)
Assuming I understand you right, you can add “Matches” criteria on the Customer table within the Business Activity Query. So, it would look something like this in the criteria tab:
Name MATCHES *Customer1*
OR Name MATCHES Customer2
OR Name MATCHES Customer3
.
.
.
Note: Asterisks act as wild cards in MATCHES searches. This website is formatting my response, but there should be an asterisk at the beginning and end of the last column for each record in my example above.
Then you can write the query to bring back all customers in a list.
create a list parameter.
“Customer1” was just an example I used as being a part of a Customer name search. To clarify, the greyed out section in my comment above would find any customer whose customer name contains the text “Customer1” somewhere in the name since I have asterisks at the beginning and end of my criteria search value.
i wasnt sure what filter to use. i am new to SQL so i dont always know what operation to use with the correct type of filter.
-
Define 8 Parameters like (I only did the first 3):
-
Add table criteria to Customer table
Blank params are ignored:
got it.
Thanks to all
If you go down this route. I would probably check the skip condition if empty, for when you don’t have all parameters with data.
Since it’s an OR based criteria, it doesn’t matter. Or does it affect the running time of the BAQ?
But that “skip condition” option does throw me sometimes.
If you use this BAQ often I’d recommend connecting it to a dashboard and you can put filters on there to bring back whatever you want.
Joe