Ask HN: Examples of inuitive yet powerful filter, slice and dice toolbars?
I'm tasked with looking into how we can add more advanced filtering capabilities to our tables - next to simple text-based search. Since this is a common problem which others will also face, let's compile a list which people can draw on for inspiration.
Two examples I'm particularly fond of:
- GitLab Issue Filters. The user is seamlessly guided by suggestions (https://gitlab.com/gitlab-org/gitlab/-/issues)
- AdminColumns Wordpress List table Filters. As with GitLab, the user is seamlessly guided by suggestions. Next to that, I'm a big fan of how the filter get translated into a human-readable description after being created. (https://www.admincolumns.com/smart-filtering/) Long ago I did this in Microsoft Access... what I did was offer a set of fields/filters to search on, and interactively built an SQL query string based on it. I toggled the display of the SQL so that I could see it (and use it for reports) but they didn't have to. It shouldn't be hard to do in any modern platform. Thanks for the pointer! You can try looking at Datasette faceted filtering/table. Thank you! I've never heard of this tool before. I just looked into it, it looks quite interesting!