Category Selector Filter doesn't search whole table, only searches what's allowed to populate from 'max categories' setting

168
1
03-04-2022 11:44 AM
MackenzieCollins
New Contributor II

Hello,

I have a couple use cases where this creates an issue.

I want to set a category filter for apn's and have that list searchable. 

MackenzieCollins_0-1646422543476.png

The issue I am encountering is that now when I start to type in an APN in the category selector that isn't in the records that are loaded (set by the maximum categories setting), it gives no result.

MackenzieCollins_2-1646422931835.png

If I set the maximum categories to load all records, it hinders performance of the dashboard by a lot.

I know I can use other lists and charts to filter this category selector, but for this to be more useful and user friendly I would like the search in the drop down to search the whole table, not just what's loaded in the first 50 records. Is that possible? Or if it did that would it just experience the same amount of hindered performance?

Thanks,

Mackenzie

0 Kudos
1 Reply
ColeMcLaughlin
New Contributor

I have this same issue, I have a table of ~10,000 records and want to search the whole table for certain field values.  The only way I can do that is to set the maximum category limit to 10,000, which bogs down the dashboard considerably.  The only solution I've found is to create multiple filters that filter eachother or just settle for the slow performance.  I hope this is fixed soon!

0 Kudos