Feature: A database filter UI that has all fields exposed and filterable to make it easier to filter using any criteria

[fancyham]

Context

Currently, on the database part of the site, there's a filtering interface, but it only has a limited number of criteria for filtering.

If it's easily possible, it could be really helpful to have a full-database search/filter interface for all organization fields in the database.

This will allow us (designers, PMs, researchers, devs) to more easily filter the database for research as well as feature development purposes.

For example, if I want to develop an advanced filter looking for "diapers", I first want to see how many orgs have 'diapers' in their text description fields. To do this, I currently need to export the entire database, then use spreadsheet software to search for that term.

How is it now?

Proposed new feature

Would like to be able to search for text or values for each field.

And for fields that have (multiple) options, it'd be nice to have a UI element that allows checkboxes for each item or text matches.

Perhaps this more complete search UI gets added to the existing filter as an "Advanced filter" screen?

Stretch goal: The ability to save a search… perhaps the filter criteria creates a unique URL that can be easily bookmarked?

Discussion

Ideally, this already exists automatically as part of the database platform we're using?

References:

• Screenshots/ videos
• Competitive Analysis (show examples of what other people are doing to solve this same problem)