Ask HN: Examples of inuitive yet powerful filter, slice and dice toolbars?

[leeuw01]

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/)

[mikewarot]

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.

[leeuw01]

Thanks for the pointer!

[raihansaputra]

You can try looking at Datasette faceted filtering/table.

[leeuw01]

Thank you! I've never heard of this tool before. I just looked into it, it looks quite interesting!