#[SOLVED] distinct

4 messages · Page 1 of 1 (latest)

quiet vector
#

This doesn't seem to be an option at the moment. Here's a Discussion and an open Issue on Github requesting this functionality.

GitHub
How to query for distinct attribute values? · appwrite appwrite · D...

after query some document in collection i only want unique values of one attribute. like: unique brand name in product details with product in one category filter.

GitHub
🚀 Feature: Aggregate Functions and Select distinct · Issue #5667 · ...

🔖 Feature description Make queries with aggregation functions like sum, count, max, etc. also with the possibility to make Distinct selects. 🎤 Pitch This feature is needed for a lot of use cases, c...

#

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.

quiet vector
#

If your issue has been solved, you can mark this post as closed by adding “[SOLVED]” to the beginning of the title

stiff mural
#

@elfin sedge, there's no need to delete your original message