datasert / realfire

Refreshing Salesforce Data Management
https://www.datasert.com
3 stars 2 forks source link

TYPEOF queries not supported #31

Open larsenp opened 2 years ago

larsenp commented 2 years ago

The following query returns records in my instance when run in Workbench:

SELECT TYPEOF What WHEN Account THEN Phone ELSE Name END FROM Task

If I run the same query in Realfire, I get the following error message:

Error parsing [SELECT TYPEOF What WHEN Account THEN Phone ELSE Name END FROM Task]. Error: missing 'from' at 'WHEN', missing EOF at 'THEN'