I used the suggestion from:
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?