🐛 Bug Report: Collections sub-navigation only shows 25

[Ricolo53]

👟 Reproduction steps

By default, 25 documents are returned, which is fine, but the panel on the left only displays 25 collections, so you have to go back to the listing page, search for the collection you want to go to, and click on it. Or have a pagnination in this panel?

This code call this function without limit queries

👍 Expected behavior

Since the left-hand panel is sorted alphabetically, I think it would be interesting to have all the collections here.

👎 Actual Behavior

Only 25, sorted in descending order of creation

🎲 Appwrite version

Appwrite Cloud

💻 Operating system

Linux

🧱 Your Environment

No response

👀 Have you spent some time to check if this issue has been raised before?

• I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• I have read the Code of Conduct

[stnguyen90]

@Ricolo53 thanks for creating this issue! 🙏🏼

You're definitely on the right track. The sub navigation only returns 25 because that's the default limit. The related code that fetches the collections for the sub-navigation, however, is here:

console/src/routes/(console)/project-[project]/databases/database-[database]/collection-[collection]/+layout.ts

Line 15 in ffb9e2d

sdk.forProject.databases.listCollections(params.database, [Query.orderDesc('')])

I'll make sure the team knows about this.

[pushkar707]

This issue seems to be fixed with a new limit of 100 collections:
console/src/routes/(console)/project-[project]/databases/database-[database]/collection-[collection]/+layout.ts

Line 17: Query.limit(100)