Back
[CLOSED] Error using relationship parameter name in select query
TypeScript
[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
TL;DR
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.
Relationship do not support queries at this moment 🥹
similar query works for different collections
As isn't officially supported I can't tell you why sometimes works and other don't, there not documentation, I have just saw this post related to Query.select(): https://discord.com/channels/564160730845151244/1096309125979320382
I don't know if that can be helpful
Error using relationship parameter name in select query
[CLOSED] Error using relationship parameter name in select query
