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