Web Developer
After the latest release, I noticed that two-deep relationships only expand correctly in the first document returned by listDocuments.
• On the first document, all attributes are included (e.g. company and company.subscription).
• On the second document and beyond, the two-deep relationships (company.subscription) only return the ID, not the full object.
This breaks consistency and makes it impossible to rely on expanded data for multiple documents.
Steps to Reproduce
1. Create a collection with a relationship (e.g. company → subscription).
2. Use listDocuments in Flutter SDK with a simple filter (e.g. Query.equal(...)).
3. Include a query like:
Query.select(['', 'company.', 'company.subscription.*'])
4. Observe the response:
• First document: company and company.subscription return full objects.
• Second document: company.subscription only returns the ID.
Expected Behavior
All documents in the response should expand two-deep relationships consistently, not just the first one.
Actual Behavior
Only the first document expands correctly. Subsequent documents return only IDs for the nested (two-deep) relationships.
Environment
• Appwrite version: 15.0.0
• SDK: Flutter 3.7.2
• Method: listDocuments
• Query: only Query.equal(...)