i am using flutter sdk (appwrite: ^8.2.2) and cloud appwrite.
When i am try to query getting an error -: Index not found: user_id
user_id is the attribute in my db.
My code is below
await databases.listDocuments(
databaseId: AppWriteConstants.databaseId,
collectionId: AppWriteConstants.colProjectUserRole,
queries: [
Query.equal('user_id', prefs.getString(PreferenceType.userId) ?? ''),
],
)
TL;DR
The user is facing an issue with a database query using Flutter SDK and Appwrite. They are getting an error "Index not found: user_id" when trying to query. The solution to this issue is to create an index for the 'user_id' attribute. The user can refer to the Appwrite documentation on indexes for more information.
