So I know how to create AND condition using the addFilter and how to add OR conditions using FilterBuilder however if I wanted to do do a search like (only using searchCriteria, no direct collection work).
WHERE (email = '[email protected]' AND status = 'pending') OR (status = 'complete' AND is_virtual = 1)
Is there a nice simple way to do this ?
