How can I do complex and advanced queries with count, sum, aggregation, grouping,… ? Thanks
I’m also having problem with data queries. Are there any tutorials or examples for complex queries? I am even having difficulties to load complex objects with one-to-many relationships? Any tips?
Hello, could you please answer that question, since it is an absolute necessity for my development ?
Thanks.
Hi, Federico.
Currently aggregation functions not supported in our service.
Support of MAX, MIN, COUNT and AVG was added to the roadmap.
All documentation for data here:
http://backendless.com/documentation/data/rest/data_overview.htm
Regards,
Kate.
The challenge here is all the specified functions go into the SELECT part of a query, but currently we support the WHERE part.
As a workaround you can add custom business logic on the server side to do additional filtering (or calculation of) the result of a query.
Regards,
Mark
Hello,
Any news on support for max, mix, count, avg, and SUM in a near future ?
Thanks.
Didier
Hi Didier,
It is in the scope for the current iteration (release 2.1). I do not have a time estimate yet.
Regards,
Mark
Is this implemented and available to use?
No, the aggregation functions are still not implemented.