Unable to have multiple items in the 'Group By' in SOQL query

[sgoode]

I am trying to run a SOQL query in Realfire that I run in Work Bench without issue.

This is not specific to this object and these columns it has this issue with any object and columns where I try to have more than 1 column in the 'Group By' in Realfire.

Query select calendar_year(createddate), calendar_month(createddate), count(id) from event_historyc where name = 'schedulingAutomation' and subjectc != '0' group by calendar_year(createddate), calendar_month(createddate)

In RealFire I receive this error Error parsing [select calendar_year(createddate), calendar_month(createddate), count(id) from event_historyc where name = 'schedulingAutomation' and subjectc != '0' group by calendar_year(createddate), calendar_month(createddate)]. Error: missing EOF at ','

If I past the SOQL in WorkBench it is successful. If I remove the second item in the 'Group By' it is successful in Realfire as well

[brsanthu]

@sgoode this is an parsing issue in Realfire. We will add support for it in up coming versions. For now, when you encounter soqls which Realfire doesn't, you can execute Direct. When you execute direct, we skip the parsing of the soql and send the query as is to Salesforce. It also means that you cannot run soqls like select * from account.

You can execute direct via:

1. Select the soql you want to run
2. Right click, select Execute Other -> Execute Direct