Filtering database for items that contain any value from the list

I am using checkbox as filters to filter a table. Once the user checks, the value is stored in a list.
Is there any way I can use this list to check if a database record contains any one of the value in the list, If it contains then display all the values.

if the list contains “BEHAVIOUR,HEALTH”. I want all the records which contain either behaviour or health. But when I see in debug bubble is checking for both “BEHAVIOUR,HEALTH”. Because of this search results are zero.

Am I doing something wrong here?


Hi there, @tech16… to do what you described, you can use an advanced filter to do a count of the intersect between the lists. So, you would have Search for Articles:filtered, and the constraint would be something like Advanced: This Article's MainTag intersect with GroupFocus Filters's SelectedFilter:count > 0.

If you haven’t used an advanced filter before, be aware that the filtering takes place on the client (browser) side. So, the search is going to return all of the articles that meet the search criteria to the client, and then the filter will be applied. Just something to keep in mind from a performance perspective.

Hope this helps.


1 Like

Thank you, will keep in mind while developing

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.