Is there a way to filter a BAQ within a dashboard for “text”? i.e. Filter for the word “Sales” in the RoleCode field. It seems you can only choose from a list of values.
You can apply a custom filter to any grid…unless I’m not understanding the question? Are you talking about filtering in a query?
I am a little rusty. I created a tracker view and that seems to be the method - right? And why isn’t there a LIKE option. Seems I have to use MATCHES and the user has to use the wildcard as in weber (my last name.
oh right. For a tracker view, it gets a little funky. You want a custom drop down to include RoleCodes that have “sales” in it? Might consider a calculated field in your BAQ, then build your tracker field from that calculated field
In the tracker, use the Wizard to add a Text changed or Value changed event to the input field. In that event, add the “%” to the front and back of the text from the first field to a hidden fields text. The hidden field will be the one that you use for the filter using Matches. The visible field is just there for the user to enter the text.