Back
indexes in appwrite db
Hey, i need help in writing query for getting documents in a collection filtered by user_id
TL;DR
The support thread is discussing how to create indexes in the Appwrite database and how to write a query to filter documents by user ID.
Solution: To create an index in the Appwrite dashboard, navigate to the index section and define it. For filtering documents by user ID, use the appropriate attribute name and set the index type as "fulltext." If you encounter any errors, provide the code causing it and a screenshot of the index section in the Appwrite dashboard for further assistance.
You need to create an index
From appwrite dashboard
If you already created one and still see such error, send here the code causing it and what you're indexing (appwrite dashboard screenshot of the index section)
@Surya Ashish
wait
Okay 😄
tell me how to write an index for this use case
You dont need to write it, go to your appwrite dashboard and define it
how to define them
what values should i put in
make index_type as fulltext
select the attribute name which you wanna query
thanks
You only need a full text index if you're using the search query. Key index is probably enough
Yeah that's what I was saying as it's related to querying
