Is there a sum() or count() function in queries?

General
1

I noticed there are several “functions” for distance matching in a where clause.

Are there any functions you can apply to props returned from a query, e.g. sum(<field>), count(<field>), etc.?

2

Not yet, but this is in the scope for the current iteration.

Regards,
Mark

3

How far off is that? A sum() function is critical for me to be able to deliver my game. Otherwise I will have to do a huge amount of data queries and movement, and processing in a script.

4

We do not set strict dates, it will be delivered when it is ready. Could take a month, maybe longer.

Consider using server-side business logic to re-calculate sum as data is added/updated.

Regards,
Mark

5

I am using server side logic, however the script needs to pull many records per user per interval (e.g. every 1 minute) to sum a value and write back. If I could sum() in a “find” query, I can do it in one step.

6

And that’s exactly why we’re adding that capability… so you can do it easier. ))

7

If that is a month or so away, that is fantastic!!! :slight_smile:

8

Any update on this? Is there a way to do that now? I don’t find anything in the docs.

9

Hi Ludwig,

It is in the schedule for the 3.2 release. I do not have a time estimate on it yet.

Regards,
Mark