Filtering RG with Keywords as "or"

[yoroanoke]

Hello,

I am having trouble with what seems like a simple task. I have set up filters in my app to filter search results of a repeating group. Currently it works great, except that it is filtering results that contain ALL filters that are selected. I would like to set it to filter if ANY filter is selected. Concretely, I want to show all RG results if “Art” or “Class” or “Alcohol” is selected instead of if “Art” and “Class” and “Alcohol”.

Currently using Advanced conditional to search for Things that contain the same list of “Tag Filters” as the Page’s custom elements Tag Filters. But when I change the conditional to just “Contains” it needs to evaluate to a yes/no.

What am I doing wrong, or is there another way to handle this tag filtering?

[net-tt]

Use the intersect function.

https://www.youtube.com/results?search_query=bubble+intersect

[marlon1]

@yoroanoke

Currently using Advanced conditional to search for Things that contain the same list of “Tag Filters” as the Page’s custom elements Tag Filters. But when I change the conditional to just “Contains” it needs to evaluate to a yes/no.

As you are using Advanced in your filter, you are able to use the “or” operator too. You just have to build the 3 Advanced conditions in 1 clause, and I think it will give you the result you want.

[adamrsousa]

I’m not sure if this is what I’m thinking, but does this work?

1. Create a join table called EventTag with two fields:
   • Event (type Event) • Tag (type Tag )
   (Every time an event gets a tag, create one EventTag.)

2. Keep the user’s choices in a custom state Page SelectedTags (list Tag).

3. Set the RG’s data source to one server-side query:

Search for EventTags
    Tag is in Page SelectedTags
:each item's Event
:unique elements

4. Tick “Ignore empty constraints” so an empty selection shows all events.