DatabasesFunctionsCloud

Query.equal error

Oct 16, 2025, 02:00Last activity 10 months ago

View on Discord

Votes

Replies

Participants

Messages

LordGavibearOriginal post

React Developer

Oct 16, 2025, 01:31

Hi guys. I'm using Appwrite Cloud, and I'm using version 21 of node-appwrite to benefit from transactions. The problem is I seem to be getting an error when I use Query.equal:

AppwriteException: Invalid query method: equal
at _Client.call (file:///usr/local/server/src/function/node_modules/node-appwrite/dist/client.mjs:294:13)
at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
at async Module.default (file:///usr/local/server/src/function/src/main.js:85:24)
at async execute (/usr/local/server/src/server.js:220:16)
at async action (/usr/local/server/src/server.js:237:7)
at async /usr/local/server/src/server.js:26:5

The relevant excerpt of the code in question that uses it is as follows:

else if(req.bodyJson.drawId){
//This means we tried to start a new conversation

  //We first check if we've already created a conversation with a matching draw
  //If we have already, we return that

  log("Trying to start a convo");
  const existingConvo = await database.listRows({
    databaseId: "68c2503d0005d71c2f12",
    tableId: "journal_conversations",
    queries: [
      Query.equal("userId", userId),
      Query.equal("draw.$id", req.bodyJson.drawId),
      Query.select(['*', 'draw.*', 'draw.card.*'])
    ]
  });

Is this a compatibility issue with the cloud?

Summary

Possible issue with Query.equal error not due to incorrect userId or variable. The getRow function may not support Query.equal. Solution: Replace Query.equal with a different method/approach for querying in getRow function.

Steven

Oct 16, 2025, 03:23

FYI, it's best to wrap code in backticks to format a bit nicer. You can use 1 backtick for inline code (https://www.markdownguide.org/basic-syntax/#code) and 3 backticks for multiline code (https://www.markdownguide.org/extended-syntax/#syntax-highlighting).

Steven

Oct 16, 2025, 03:25

Maybe userId is invalid?

LordGavibear

Rank 1: Thread

Oct 16, 2025, 03:48

No the column is properly named and the variable I'm checking against is defined, so thats not it.

LordGavibear

Rank 1: Thread

Oct 16, 2025, 04:05

Actually looking at it, I gave the wrong part - the error seems to be in this line:

Plain text

        databaseId: "68c2503d0005d71c2f12",
        tableId: "draws",
        rowId: req.bodyJson.drawId,
        queries: [
          Query.equal("userId", userId),
          Query.select(['*', 'card.*'])
        ]
      }); ```

Is it that getRow doesn't support queries?

LordGavibear

Rank 1: Thread

Oct 16, 2025, 04:09

Ok I got past it, apparently getRow doesn't support Query.equal

Join the discussion

Reply to this thread by joining our Discord.

Reply on Discord

Need support?_

Join Discord Get premium support