I am very new to DreamFactory. I have installed DreamFactory 2.0 using Bitnami installer OSX. Also create a service to connect our Salesforce.com and it works great.
When i use the endpoint to getRecords i.e /api/v2/Salesforce/_table/Opportunity. I am unable to use GROUP and ORDER successfully.
I get an error - MALFORMED_QUERY Field must be grouped or aggregated
how can i map a query like the one below to the with the params of the auto generated API endpoint.
PS: I am able to query and get response from for simple query which do not have field name aliases or SUM()