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?
Use an aggregate model and snippet to generate the options. Can even include the qty in choice.
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
Awesome!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.