I’m looking to run a query on a table that counts the number of rows up until a particular condition. An equivalent query in standard SQL would follow this format:
The capability to run statistical SQL functions (SUM, MIN, MAX) is not supported yet. It would not be possible at this point to create a single query which would do what you’re after.
We are planning to add support for these in version 4 of Backendless.
I had need the sum function I know it is not available, but I do this in a while loop, it works but my worry is that backendless returns only 100 result, and to verify the account of my users I have to go through all Its transactions in my table “crediter”
With Backendless Cloud you will get 100 objects for each request. You can use paging to get all of the data in multiple requests. With Backendless Pro and Managed Backendless, the limit on how many objects are returned does not exist.