This doesn't seem to be an option at the moment. Here's a Discussion and an open Issue on Github requesting this functionality.
The recommended approach for doing something like this is to maintain a metadata collection and update the metadata with every document create/update/delete event. Then, you can fetch that metadata collection/document to get the unique values.
If your issue has been solved, you can mark this post as closed by adding “[SOLVED]” to the beginning of the title
@Sabiyo, there's no need to delete your original message
[SOLVED] distinct
Recommended threads
- executeFunction intermittently throws Fo...
Environment: Flutter app using the Appwrite Flutter SDK, calling executeFunction for [describe endpoint, e.g. live-stream-related function]. *Description*: Int...
- How to update from 1.8.1 to 1.9.6
Due to the number of issues reported in version 1.9.5, I am hesitant to proceed with the update. Could anyone advise if version 1.9.6 is stable and resolves tho...
- HTTP Error 500 ''
Hello to everyone, I'm a Flutter developer and actually I'm developing an app using Appwrite.. during my tests and also massive ones I've noticed something we...