Back
Complex Queries
what is the best way to use to queries for statistical report. multiple condition and multiple rows
TL;DR
The user is asking for the best way to use queries for a statistical report with multiple conditions and rows. The recommended approach is to keep functions separate and clearly defined to avoid overlaps or duplicates. Indexing should also be considered to optimize performance.
Hi! here's an example to use queries https://appwrite.io/docs/databases#querying-documents
The best way could be to keep functions separate and clearly defined so there are no overlaps and/or duplicates. Also try looking into indexing https://dev.to/appwrite/how-do-i-index-my-appwrite-collection-2o4n
