Hi everyone!
I’ve been using for a project Appwrite, but I've been stuck by an error when using Query.equal in a function named getCurrentUser() . So the function is as follows:
export async function getCurrentUser() {
try {
const currentAccount = await account.get();
if (!currentAccount) throw Error;
const currentUser = await databases.listDocuments(
appwriteConfig.databaseId,
appwriteConfig.userCollectionId,
[Query.equal('accountId', [currentAccount.$id])],
);
if (!currentUser) throw Error;
return currentUser.documents[0];
} catch (error) {
console.log(error);
}
}
The problem is when I test it a general_query_invalid error message appears with the following content:
{
"message": "Invalid query: {\"method\":\"equal\",\"attribute\":\"accountId\",\"values\":[\"660844b00029df0d3719\"]}",
"code": 400,
"type": "general_query_invalid",
"version": "0.12.130"
}
Find attached a picture of the USERS collection in the database, with the user trying to query to.
I reviewed the docs from appwrite and did not find anything different, so I don't understand why is it failing. I also reviewed the environment variables which are correctly used and tables in the database contain the needed fields to perform the query equal operation.
Has anybody experienced the same problem? Could you please help or point me in the right direction to solve the problem?
Version used:
"appwrite": "^14.0.0",
Thanks in advance for your help and support!! 😄
Recommended threads
- TablesDB `updateRows` returns `database_...
Hi Appwrite team! I’m seeing a strange issue with TablesDB bulk row updates on a self-hosted Appwrite instance. **Environment** - Appwrite self-hosted `1.9.0` ...
- Update row sheet not loading
After right clicking a row header and click update, the sidebar fails to load (never-ending skeleton)
- Bug report: Race condition in Flutter SD...
Hi team, I've found an intermittent bug in the Flutter SDK (v20.3.0) when using `createOAuth2Session` on Android. **Symptoms** After `createOAuth2Session` re...