0 Replies Latest reply on Oct 6, 2018 4:46 PM by Jerry Hall

    Filtering one column w/ multiple pipe-separated items

    Jerry Hall

      I created a Parameter with a list of potential items (up to 8 items per record and about 100 options, all pipe-separated) found in my column such as this:

       

      "DISORDERLY PREMISES | FL'D TO QUALIFY MANAGER | LEWD CONDUCT | VIOL. OF CONDITIONS"

       

      That said, I also have 8 other columns in my postgres table with items individually stored (in case your suggestion might use that data source?)

       

      However, when I create a filter I only get a single-selection radio button and not a multi-select option.

       

      How would I create a multi-select filter where I could select one or more items (eg, check LEWD CONDUCT and VIOL. OF CONDITIONS) and if one or both are in the record that record displays in my table?

       

      I did create another sheet and used the above data column as the filter but, it can get really long (eg 200 characters) so isn't usable. I too understand people can do a search but, that limits them significantly.

       

      Thanks for any help!