from Hacker News

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

by leeuw01 on 8/2/21, 1:06 PM with 4 comments

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

  • by mikewarot on 8/2/21, 6:50 PM

    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.

  • by raihansaputra on 8/3/21, 12:21 PM

    You can try looking at Datasette faceted filtering/table.