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