Hello, I have a userData collection which stores a users info like address etc. I have a couple of relationships with other collections which could have a lot of data related to the user. My question is when i query the userData document for a user I see that I get returned the related collections documents also. My question is how many records will it return, i'm guessing its the rate limit of 25. I'll need to know since one of the related collections is userEvents and will eventually have a decent amount of data. What I do know is instead of querying the userData and separately querying the userEvents I just query the userData and add the userEvents to a list because the data is already there. How will this work with pagination and what order does the related collection data come in? from the last created to the oldest or from the first created to the newest? Is there an option to control this?
Thanks!
final data = await ref.read(databaseProvider).listDocuments(
databaseId: Database.databaseId,
collectionId: Collections.userData,
queries: [
Query.equal('accountId', ref.read(sessionController).currentUser!.$id)
],
);```
Right now, all the related data is returned 😅
We plan to add a way to paginate
I guess no worries for the time being. Thanks!
Relationship and Rate Limit [SOLVED]
[SOLVED] Relationship and Rate Limit
Recommended threads
- DB connection | Got timeout reading comm...
When looking at the logs of `appwrite-mariadb` I'm seeing a lot of: ``` 2026-04-09 7:37:28 10 [Warning] Aborted connection 10 to db: 'appwrite' user: 'appwrit...
- Invalid document structure: Unknown attr...
Environment: Dart version: 3.5.1 dart_appwrite: 13.0.0 I’ve already created the database structure using a Dart function. I can create data records using cloud...
- android platform invaild origina
It happened today suddenly. Our app says invalid origin. And appwrite cloud says every time we tried to add the app to it: "param platformId" is not optional.