Issue with 'Do a search' filtering with 'OR' condition for a list of values within a list column

[drew2]

I tried to filter out using a list of values with a text list column using ‘contains’. However, I want it to get if any value exists in the given list of values,
Ex:
rec 1: apple, orange, pineapple, mango.
rec 2: apple, mango

filter value: apple, pineapple.
expecting results: : rec 1, rec 2 (because both has ‘apple’)
response result:; rec1 (because 2nd record don’t have ‘pineapple’)

currently, it is trying to match the entire value with the database value. But I want it to respond if any value exists, in short, I expect an ‘OR’ condition, but the result is an ‘AND’ condition.

[hergin]

You have to do an advanced filter. After doing the search, go to filter operator with advanced and filter value intersection with this item's keywords: count should be greater than 0.

[drew2]

"I removed the direct filter constraints and tried using ‘intersect’ but couldn’t understand how to achieve the desired result as you suggested.

[hergin]

You wont intersect here. In this one, you will choose filter instead of intersect, then select advanced, and then this thing's tags intersect with Filter MD:values: count > 0.

[drew2]

I don’t find filter then advance, I can only found filter and other some other options.

also when I selected filter then intersect instead of advanced(that you mentioned) I can see this page as a primary option, but not this thing or this text…

[hergin]

It is inside the filtered. You can see it by adding a new constraint:

[drew2]

You mean like this? But result gone empty, But the all the search field values are empty. it should response all the results.

[hergin]

I mean now you know where it is. You should structure it with respect to your needs. But I suggest you start with one first to see if it is really working like the way you want.