Skip to main content
Nintex Community Menu Bar
Question

Show more than 25 items in a Select Option Filter

  • July 9, 2024
  • 2 replies
  • 2 views
A
Forum|alt.badge.img+3

I used the suggestion from: 
https://community.skuid.com/t/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



    2 replies

    Z
    Forum|alt.badge.img+13

    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. 

    81d5dd19894d9750fbe0005b974110a0a1b9b21f.png

    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. 


    A
    Forum|alt.badge.img+3

    Zach,
    That did the trick! Thank you for the super speedy response, I really appreciate. 
    Andy

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement