[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

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.

As for any database action I recommend you back up every thing before.

How can i make backup.

Check these two
Backup scripts

• https://gist.github.com/Meldiron/47b5851663668102a676aff43c6341f7
• https://gist.github.com/stnguyen90/fee636ff652b8ecbf761935b2aa254fb

ok,

How to use index for asc and dsc with respect to time

Didn't got it

means, how can i arrange my data in ascending order using time stamp,

You can use one of these queries

https://appwrite.io/docs/queries#query-class

can i also use index?

You can use the attribute on if it is an index one then it will work faster
But as of version 1.3.0 it will work in any case.

ok, what is the use of Key and Full Text in index Type, as i am only aware with Unique

$createdAt this is my attribute which is in build attribute from appwrite, tried this but not working.

this is working thanks

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