Filter filter options (and/or respect field lookup filters)

  • 1
  • Question
  • Updated 2 years ago
  • Answered
Just like you have the option to filter lookup fields in a field editor...



 it would be useful if we could employ the same configuration ability on filters in filtersets and table filters instead of getting irrelevant data that the user then has to sort through visually.

Photo of Shmuel Kamensky

Shmuel Kamensky, Champion

  • 4,328 Points 4k badge 2x thumb

Posted 2 years ago

  • 1
Photo of Shmuel Kamensky

Shmuel Kamensky, Champion

  • 4,328 Points 4k badge 2x thumb
Has anyone figured a workaround for this?
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb
Only workaround I know of is to use a ui-only picklist field as a filter (so you're using a field editor instead of a filter component). There are a few examples on the community, but I'm too lazy to look them up now.
Basically, you're using javascript to render the field with the filtered picklist, and then you can use the ui to set the value of a condition and query when the field is changed.
Photo of Shmuel Kamensky

Shmuel Kamensky, Champion

  • 4,328 Points 4k badge 2x thumb
Wow that was simpler than I thought. I needed a multi select picklist. Never used a model as a source for multi select picklist before. Thanks Matt!