soqlDatatable unexpected token: OR

[huuse]

The soqlDatatable does not seem to support using OR in the WHERE conditions. Is this by design?

Error: Invalid SOQL String unexpected token: OR

[tsalb]

You’ll need to give the full soql string for debugging, it might have to do with how it splits and expectations of where keywords are.

You’ve confirmed it runs in dev console or another tool?

[huuse]

Thank you for your response. Yes, a simplified version looks like this: SELECT Id, Name, Email, MobilePhone FROM Contact WHERE Email = '[email protected]' OR MobilePhone = '+4792699599'

Running this in dev console works, but not in soqlDatatable. Same error.