obiwanzenobiOriginal post
Rank 3: Container
[Error] Method: GET
[Error] URL: /v1/databases/:databaseId/collections/:collectionId/documents
[Error] Type: PDOException
[Error] Message: Unknown column 'table_main.assignedToCategories' in 'field list'
[Error] File: @swoole-src/library/core/Database/PDOStatementProxy.php
[Error] Line: 62
select([\"$id\",\"zdayId\",\"$permissions\",\"assignedToCategories.*\"])
assignedToCategories is relationship
Summary
The user encountered an error when using the relationship parameter name in a select query. They mentioned that there is no official documentation and provided a link to a related post on Discord. The user also mentioned that a similar query works for different collections. However, someone stated that relationships do not support queries at the moment. The error message suggests that there is an unknown column 'table_main.assignedToCategories' in the field list.
Solution: Unfortunately, there does not seem to be a solution provided in the support thread. The issue may be related to the lack of support for relationship queries.