Aggretation in Backendless?

General
1

Hi,
I’ve read that Backendless does not currently support aggregate function as of the moment. So my question is, how would one do this alternatively?
Let’s say I want a report with average value monthly, quarterly and yearly?

Sorry for the noob question but I’m pretty new at the NoSql architecture. Normally in a SQL, I would do something like:

SELECT AVE(value), TRUNC(date,'M')
  FROM my_table
 GROUP BY TRUNC(date,'M')

Thanks,
Allen

2

Hi Allen,

The aggregation functions are not supported yet, but are on our roadmap. We’re currently working on a major release, which will then include this functionality. Unfortunately, can’t provide any estimates yet.

3

Thanks Sergey.

Can you recommend any alternative approach in the meantime?

4

The only alternative for now is to do aggregation on the client manually.

5

Just to clarify that we’re on the same page, doing this “client manually” meaning using a local database like SQLite to store server data locally? Is this what you meant?

6

I mean, you can load all the data and then group it into some Map or anything. You don’t actually need a local database for this.

7

Sounds good.

Thanks.