Exclude options in automatic filter where there are no records in my model with those values

  • 1
  • Question
  • Updated 12 months ago
  • Answered
Automatically generated filters are great! But I must be missing something, because I don't want to show options that would filter for 0 records.

How do I exclude options from the filter if the model does not have any records that match that value 


Also, any idea why my "Other" option wouldn't be showing here?
Photo of Conlan O'Rourke

Conlan O'Rourke

  • 3,280 Points 3k badge 2x thumb

Posted 12 months ago

  • 1
Photo of mB Pat Vachon

mB Pat Vachon, Champion

  • 42,714 Points 20k badge 2x thumb
Use an aggregate model and snippet to generate the options. Can even include the qty in choice.
Photo of Conlan O'Rourke

Conlan O'Rourke

  • 3,280 Points 3k badge 2x thumb
Awesome! Didn't even need the Snippet, I just used a filter with Select Option - Manually, and used Rows in a Model (with the aggregate model) as the Option Source

Photo of mB Pat Vachon

mB Pat Vachon, Champion

  • 42,714 Points 20k badge 2x thumb
Awesome!