I have received quite a few requests from end users to be able to filter on a list of values (comma, semicolon, or carriage return separated). As far as I know, this is not possible within the DSP framework.
For the time being, I have told the end users to download the data and then use a VLOOKUP in Excel. Not an ideal (or fast) solution, but it does work.
Is there a way to paste a list of values and allow DSP to perform an IN statement as opposed to a LIKE statement in the filter section?
The only solution that I can think of would be custom and as follows.
- Create a page that allows for end users to enter the required values.
- Create a function, stored procedure, table valued function, etc, that will transform this data into a (temp or permanent) table
- Click button (or something similar) to navigate to another page that will join back to this data set.
Not pretty, but it would work. The problem is that it is not dynamic and the fields available for filtering would need to be hard coded into a view.
As I type this, I realize that there's a lot here. Just trying to get my thoughts out on a potential solution and see if there is something else available out there within the DSP framework.