[SOLVED] why appwrite (console) shows only 5k documents, but there is more then 10k documnets

why appwrite (console) shows only 5k documents, but there is more then 10k documnets

TL;DR

The user was experiencing an issue where the Appwrite console was only showing 5k documents instead of the expected 10k. However, the user later thanked for the solution, but it is not mentioned in the thread. There were also questions about using attributes, indexes, and queries. The user wanted to arrange data in ascending order using timestamps but did not fully understand the solution provided. The user asked how to make backups and delete all documents in a single click. The solution provided was to create a script for the database creation to easily delete and recreate the collection. Alternatively, accessing the database directly and emptying the collection table

There is an hard limit on regular pagination. up to 5K only.

is there is any way to search documents on console

I don't think so

and for deleting all documents in single click

Also, I think the only to delete is by ID. It would be nice if you can empty collection.

For now you can

Make sure your database creation is in a script then it would be easy to delete and recreate the collection.
Access the database directly and empty the collection table.