Forum Academy Marketplace Showcase Pricing Features

Complecated query that combines AND and OR

【 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?