Order By does not allow aggregate queries

jetstreamapp / soql-parser-js

Javascript SOQL parser

https://jetstreamapp.github.io/soql-parser-js/

MIT License

77 stars 20 forks source link

Order By does not allow aggregate queries #103

Closed paustint closed 4 years ago

paustint commented 4 years ago

[ ] Feature
[x] Bug

Description

Salesforce supports aggregate functions in the order by, but parsing fails. Example query: SELECT ProductCode FROM Product2 GROUP BY ProductCode HAVING COUNT(Id) > 1 ORDER BY COUNT(Id) DESC