【 What we want to achieve 】
(fieldA = StateA and fieldB contains StateB) or (fieldC = StateA and fieldD contains StateB)
【 What we tried 】
①fieldA = StateA and fieldB contains StateB or fieldC = StateA and fieldD contains StateB
→result: 「fieldC = StateA and fieldD contains StateB」works but 「fieldA = StateA and fieldB contains StateB」doesn’t work
②Do search 〇〇 :filter(Advanced: fieldA = StateA and fieldB contains StateB) merged with
Do search 〇〇 :filter(Advanced: ieldC = StateA and fieldD contains StateB) :unique elements
→result:same as ①:「fieldC = StateA and fieldD contains StateB」works but 「fieldA = StateA and fieldB contains StateB」doesn’t work
How can I solve this problem?