I made a dashboard with a BAQ, and I am trying to make the dashboard select multiple parameters for the baq. I have searched through multiple threads about this, but I could not find something that works for this.
What I thought would work is doing an IN statement for the parameter.
Yeah if you want no slide out, you have to not use parameters. I believe you want to create a dashboard from your BAQ. But first, make a copy of your BAQ and remove the parameters from your the copy. Build your dashboard based on that copy. Do all the filtering using Application studio.
Can you share the param value expression? I suspect it’s passing a tilde delimited list rather than one expected by t-sql IN clause. So your BAQ works for in(‘dept1’) but not for in(‘dept1~dept2’). If that’s the case, you can Convert to sql like so:
I already changed the baq to just have 4 separate parameters, since that was the easiest. But I do know for sure that the application was selecting multiple values with a tilde in between them, that is what the text boxes showed. I will make a copy of the menu and BAQ and get back to you with what the results are. Thanks!
So I tried this, but it looks like when I convert the search filter to SQL, nothing shows up. This happens with a single selection or multiple selections on an erp-selection-list.
I had it as an IN with a list because I figured that would work for selecting multiple objects. I figured since you mentioned parameters in your post, that parameters would be needed for this. I tried it without parameters, using the provider model in the grid, and that did not work either.
The BAQ itself works fine when I run it with the following parameters.
To see what it really doing we’d have to look at the BaqExecute request in the browser webtools (F12). But it’s coming back to me now, params are different.
What I believe will work is making the BAQ param optional and passing the IN() using BAQ Where like this:
I confirmed that the parameter in the BAQ allows empty values.
I just ran the application again with the browser tools (I forgot you had to turn on debug mode, that was where I was confused) and it looks like the issue is that the expression must have a join clause.
The action widget does not seem to have a where list property. Just the parameters and execute option. However, the panel grid does have a where list in the grid model > provider model > baq options. I was not using that.
I tried to do IN with the where list in the grid model. The parameters were removed from the original BAQ, and I added the following to the where list (along with the date options). I tried one ? as well.
With this, selecting multiple items on the list gives me everything that the original BAQ would get, including things outside the date range. Selecting nothing will get me all resource groups within the date range. Selecting one will show nothing in the grid.
