Show more than 25 items in a Select Option Filter

  • 1
  • Problem
  • Updated 4 years ago
  • Solved
  • (Edited)
I used the suggestion from: 
https://community.skuidify.com/skuid/topics/filter_based_on_distinct_or_aggregate_query
 to build a filter list of distinct Opportunity Owners and it worked great in the sandbox, but puked in production due to the number of owners. I have an aggregate model that brings back all opportunity owner ids and last names.   If I do not limit the model to return 20 rows the filter select list just builds with 'Any Owner' and not the list of owner last names. 

  • Should I be able to build a filter list with more than 20 options? I would need about 35 to make this work
  • Is there a better way to build a filter of distinct opportunity owners?

Thx
Andy
Photo of Andy Chasin

Andy Chasin

  • 382 Points 250 badge 2x thumb

Posted 4 years ago

  • 1
Photo of Zach McElrath

Zach McElrath, Employee

  • 49,056 Points 20k badge 2x thumb
Andy,

Filters can either display as Autocompletes, or specific,listed-out options. It sounds like you're looking for them to display as listed-out options, rather than as an Autocomplete. By default, Skuid makes this transition at 20, which is the "break" behavior you're experiencing. 



So here's how to avoid:

1. Remove the Limit on your Aggregate model.
2. In your Filters' properties, change "25" or "20", whatever is within the red box above, to something huge, like 100. 
Photo of Andy Chasin

Andy Chasin

  • 382 Points 250 badge 2x thumb
Zach,
That did the trick! Thank you for the super speedy response, I really appreciate. 
Andy