Assuming I have a bunch of records in a table called LessonBundle with a Version column of type int, is it then possible to do the following with BackendlessDataQuery?
BackendlessDataQuery findLatestVersionQuery = new BackendlessDataQuery();
findLatestVersionQuery.setWhereClause("MAX(Version) AND Platform='" + lessonbundle.getPlatform() +
I’m trying to do this in the beforeCreate CBL method.
Currently max() and min() functions not supported in data service.
I am adding support for MAX, MIN, COUNT and AVG to the roadmap.
No, not yet. It will show in version 4 though.
It is available ?. I want to use from codeless
Yes, it’s available.
You can read more about aggregate functions:
Aggregate Functions Overview
To use aggregate functions in Codeless, use the Load Table objects block from Data API