Back
Appwrite Query (SUM, GROUP)
Extra features such as sum and group are needed for Appwrite Query. Is there a plan for this or could these features come in future versions?
Or how can I solve these problems like creating a view in the database?
TL;DR
Unfortunately, the current version of Appwrite Query does not support features such as 'sum' and 'group'. However, there are a couple of workarounds that you can try. One option is to write a function that runs periodically and paginates over all the documents to get an exact count. Another option is to use the 'sum()' function from the listDocuments method, although it is capped at 5000.
While there is no definite timeline for when new queries will be introduced, you can leave your thoughts and suggestions on the Appwrite GitHub discussion page provided in the thread. Creating a view in the database is not 
Hi,
You might want to see this https://github.com/appwrite/appwrite/discussions/3545 It is hard to say the exact time when we introduce new queries but you can leave your thoughts here.
For now you can use sum() from listDocuments, which is capped at 5000.
If you need exact count, you can write a function that runs every t minutes, and it paginates over all the documents. That will give you exact count.
