Multi-Select filter option for non-picklist fields

  • 4
  • Idea
  • Updated 2 years ago
  • Implemented
In the new Superbank release, there's now the option to add a multi-select filter to a table. This is great but only seems to allow picklist fields to be used. We really need to be able to use fields like "OwnerId" (for multiple user filtering) and "RecordTypeId" (for multiple record type filtering). Could we not provide a model for the selectable options like we can currently with a regular "select option" filter?

It would also be great if the new automatic condition table filtering could use non-picklist fields.
Photo of Oliver Sinfield

Oliver Sinfield

  • 922 Points 500 badge 2x thumb

Posted 5 years ago

  • 4
Photo of Pat Vachon

Pat Vachon, Champion

  • 44,396 Points 20k badge 2x thumb
Got this work without issue by manually setting the table filter type to "multiselect" and conditions to multiple specified values.



Resulting queries work as expected.
(Edited)
Photo of Jared Jones

Jared Jones

  • 2,224 Points 2k badge 2x thumb
Hi Pat - What did you do to be able see the soql in the developer console?  I'm using this method, but when I deselect all, apply, it appears the table is filtered as Region = "" (none).  The second time I deselect all, apply, then I get the expected Region = any.
Photo of Pat Vachon

Pat Vachon, Champion

  • 44,396 Points 20k badge 2x thumb
Here you go.

Photo of Jared Jones

Jared Jones

  • 2,224 Points 2k badge 2x thumb
Thanks for the fishing lesson, Pat.  Hope you have a great weekend!