GuilleOriginal post
Moderator
I'm trying to get a list of documents with the following code:
TypeScript
const lastQueries = [Query.orderDesc("date"), Query.limit(1), Query.equal("profile", profile.$id)]; const lastMarkin = await databases.listDocuments<MarkinProps>(DATABASE_INTERNAL, "markin", lastQueries);And I get this error:
appwrite | [Error] Timestamp: 2023-08-28T16:38:52+00:00
appwrite | [Error] Method: GET
appwrite | [Error] URL: /v1/databases/:databaseId/collections/:collectionId/documents
appwrite | [Error] Type: PDOException
appwrite | [Error] Message: Unknown column 'profile' in 'where clause'
appwrite | [Error] File: @swoole-src/library/core/Database/PDOStatementProxy.php
appwrite | [Error] Line: 64
This happens only when I add Query.equal("profile", profile.$id).
The markin collection have this attributes: workday (relationship), profile (relationship), date and isComputed and a unique index for the date attribute.
I have tried, recreating the markin collection but I keep having the same error
I'm on appwrite v1.3.7
node-appwrite v9.0.0
I haven't migrating recently, it was working before.
The only recently change was to add markin relational attribute to a workday
Any clue on how to solve this?
Summary
I'm getting an error message saying "Unknown column 'profile' in 'where clause'" when trying to query a collection in Appwrite. This error occurs when I add `Query.equal("profile", profile.$id)` to the code. I have not made any recent migrations, and the only recent change was adding the `markin` relational attribute to a `workday`. Any suggestions on how to solve this?