Is SQL Max() and Min() functions supported on Data Service?

Data Service
1

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.

2

Hi, Simon.

Currently max() and min() functions not supported in data service.

Regards,
Kate.

3

Hi Simon,

I am adding support for MAX, MIN, COUNT and AVG to the roadmap.

Regards,
Mark

4

is it available now?

5

No, not yet. It will show in version 4 though.

6

It is available ?. I want to use from codeless

7

Hello @Vinod_Sahu

Yes, it’s available.

You can read more about aggregate functions:
Aggregate Functions Overview
AVERAGE
COUNT
SUM
MIN
MAX

To use aggregate functions in Codeless, use the Load Table objects block from Data API

8

Thank you