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/)
You can try looking at Datasette faceted filtering/table.
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.