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

3 pointsleeuw014y ago4 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/)

4 comments

mikewarot4y ago

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.

leeuw01OP4y ago

Thanks for the pointer!

raihansaputra4y ago

You can try looking at Datasette faceted filtering/table.

leeuw01OP4y ago

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

j / k navigate · click thread line to collapse

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

3 pointsleeuw014y ago4 comments

Two examples I'm particularly fond of:

- GitLab Issue Filters. The user is seamlessly guided by suggestions (https://gitlab.com/gitlab-org/gitlab/-/issues)

4 comments

mikewarot4y ago

leeuw01OP4y ago

Thanks for the pointer!

raihansaputra4y ago

You can try looking at Datasette faceted filtering/table.

leeuw01OP4y ago

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

j / k navigate · click thread line to collapse