Multiple Category Sorting with HubDB

hubdb

#1

We are working on a resources page that sorts based on multiple topics. The client would like the functionality to include the ability for a user to select multiple topics and the 'best match' to appear on top, the 'best match' being when multiple topics are chosen the resource matching the most topics to be at the top of the page. This seems rather intuitive but our developer is saying it is not possible. Is it possible. Please let me know if more clarification is needed.

Here is a link to the page as it exists right now: https://www.eventusg.com/eventus-res

Thanks!


#2

Hi @Seth_Fendley,

If the 'topics' column is multiselect, you can take advantage of the contains filter to pull only rows that contain each of the selected values. You can also use the __in filter to pull rows that have at least one of the selected values, which would allow you to surface rows that don't match all filters, but do match some. You can find more details below: