DatabasesFunctions

Query the list of values for a specific attribute but remove duplicates

Mar 30, 2024, 23:00

View on Discord

Votes

Replies

Participants

Unknown

Messages

ewicOriginal post

Web Developer

Mar 30, 2024, 22:21

Imagine I have a collection of stock data, where there is a "symbol" attribute for each document. In my python function I want to query my collection to return a list of "symbol" attribute values that are unique.

i.e. If I had 3 documents and 2 of the documents had their symbol attribute as "AAPL", and the third document had their symbol attribute as "MSFT", the query would return a list of ["AAPL", "MSFT"]

Summary

Query the database to retrieve unique values of a specific attribute. To achieve this, the developer can use the `distinct` option in the `list_documents` method. Here's how to modify the existing code: ```python docs = databases.list_documents( DATABASE_ID, COLLECTION_ID, queries=[ Query.distinct(['symbol']) ] ) ``` By adding `Query.distinct(['symbol'])`, the query will return a list of unique values for the "symbol" attribute.

ewic

Web Developer

Mar 30, 2024, 22:49

Python

# Query Database for list of unique symbols
client = (
    Client()    
    .set_endpoint('https://cloud.appwrite.io/v1')
    .set_project(PROJECT_ID)
    .set_key(APPWRITE_API_KEY)
)

databases = Databases(client)   

docs = databases.list_documents(
    DATABASE_ID, 
    COLLECTION_ID,
    queries=[
        # What queries do I add here?
        Query.select(['symbol'])
    ] 
)

Query the list of values for a specific attribute but remove duplicates

Need support?_