How to use Logical Comparison for Inline Fields

What I’m trying to do

Filter notes based on two or more values from an inline field.

Background: A simple inline field that has a single value chosen from a list
Using a single value works as expected thus:

Table
where inline=“A”

Things I have tried

Table
Where inline=“A” or “B”

Table
Where inline =(“A” or “B”)

Table
Where contains(inline, “A” or “B”)

Table
Where contains(inline, (“A” or “B”))

I get no results returned for the “OR” statement.
I test for each value individually using the code at the top and the correct result is returned, so what I don’t understand is how to create a logical combination.

Any guidance would be greatly appreciated.

Thanks

Does this work?

TABLE
WHERE contains(inline,“A”) OR contains(inline,“B”)

Edit: This should then also work

TABLE
WHERE inline="A” OR inline=“B”

Thanks!
Both solutions worked.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.