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

  • 1
  • Question
  • Updated 1 year ago
  • Answered
  • 1
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,632 Points 3k badge 2x thumb

Posted 1 year ago

  • 1
1 year ago
Photo of mB Pat Vachon

mB Pat Vachon, Champion

  • 42,804 Points 20k badge 2x thumb
Use an aggregate model and snippet to generate the options. Can even include the qty in choice.
2017-11-28T17:19:43+00:00
Photo of Conlan O'Rourke

Conlan O'Rourke

  • 3,632 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

2017-11-28T22:51:26+00:00
Photo of mB Pat Vachon

mB Pat Vachon, Champion

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

Powered by Get Satisfaction