So when you make a dashboard, you can put in the tracker and make filters for fields. It’s really nice because it parameterizes the query and the more filters you have populated, the faster the query returns the results. The only problem is, I can only put one value in that field. I can make a little less specific by using starts with, or greater than or something, but I don’t know of a good way to make it so I can put two (or more) totally unique values in to filter the results. There are a couple of ways of doing it that I don’t like much.
One is to run the query wide open and then use the grid filters to filter after the query is run. The problem with that, like I mentioned before, is with a large data set, this can take a long time to run. The other is to add a list in the parameters of the BAQ. In certain contexts, with the right people using it, that works pretty good. However, what I am doing requires large volumes of transactions with shop floor workers, and that extra step will end up being a problem. What I would like to do, is to be able to have more than one text field, and then have the query run with multiple filters. Hence, see if I can use the Dynamic query adapter to filter on what’s in the text boxes as the query is run that would be the best solution. The trace is from the refresh button, but maybe it would be better to call my own method instead built in refresh?