UDGrid and Filters

I have a number of grids I am presenting with anywhere from 600+ records to over 15,000+ records. I am using server-side processing to speed up the loading of the grids and that works really well.

Where I am running into a challenge is the user experience when they use the built-in filter function. A lot of this is because it starts filtering as soon as a user starts typing. I have found for myself (I can type fast) that I can type around five characters on a normal basis and the filter will work. I have other users, though, who are having a lot more challenges. For example, if they are looking for “smith”, they will type the “s” (and the filter starts working) and they keep typing the “m” (which now overrides the “s” and just does a search on “m” - again with a bit of slowness as it filters). Eventually, by the time they get to the “h”, it will only complete a filter on the letter “h” and not provide the results they want. (Clearing the filter also usually requires selecting the entire text and deleting it before starting a new search. It definitely takes training to get users used to it and I get a ton of complaints.)

Ideally, I would love to build in a small delay (like 5 seconds) before it starts filtering. I think this would provide a much better user experience and be a lot less frustrating for users. To compensate for some of the pain points on this, I have created some search dialogs that feed to some other grids, but I also want to continue to provide some grids that give the user the ability to do a bit more browsing (in case they aren’t sure how to spell someone’s name).

What have others done on large grids to help with these types of filtering issues? Are there other choices I may be missing to help with this?

Thanks for any ideas.

Hey @dkkazak I know what you mean on the grid side…I normally end up showing users the export to CSV then to filter it from there…however to tackle the problem of loads of data in grids, I am displaying:-
Underneath my grids…I got a sales guy yesterday to create his own pivot table heat row map in 5 mouse clicks! This then displayed his data exactly how he wanted it…for me this was a massive win, as the years I have spent doing stuff for this guy in excel, and now he can do it himself via this component I published…it’s not 100% solution to your problem, but allows you to display the grid data in numerous different ways even charts! I will be writing a blog on this soon, as this component for me is a massive game changer :crazy_face:

I actually do love your pivot table as it is meeting some of my other needs. You have added some great components to the UD community and I really appreciate it.

Unfortunately, the grids really just provide links to other information, so exporting it to a CSV and the pivot table won’t meet these needs.

Hi @dkkazak,

I’ve heard this complaint from a user once, and was quickly resolved by sending a link to a “how to type faster” website.

I can see the usecase however, and i suggest you open up a github enhancement request:

I believe this issue is mainly with the -serversideprocessing enabled, as the client will request new data whenever the filter is edited.

Sounds good. I have opened an enhancement request here: https://github.com/ironmansoftware/universal-dashboard/issues/1492


1 Like