indexes in appwrite db

Hey, i need help in writing query for getting documents in a collection filtered by user_id

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