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:
Where inline=“A” or “B”
Where inline =(“A” or “B”)
Where contains(inline, “A” or “B”)
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.