I have a filter table, where it has the fields: id(number), name(text) and filtered(boolean)
I also have another table called files
where there is the filter list field, which is basically of type filters (table)
I have a repeating group, and I would like to display only files for which any of the filters are yes
example: one of my records has a list in the filter list field with the ids: [36, 37, 38] if one of the ids is yes in the filters table, then show the file
What I’ve achieved so far is: show the file if all filters are selected:
example: if 36 is selected, nothing appears, but if 36, 37 and 38 are selected, then the file appears
with this formule
How can I do it so that, if any of the ids are yes, the file appears, instead of needing to select all the filters it has?