Joystream / Joystream/joystream
QN error: forumThreads > "orderby: initialPost_ASC" missing column
- Dominant language
- Rust
- Stars
- 1.4k
- Forks
- 116
- PR merge metrics
- No merged PRs in 30d
Description
Notes:
- Removing orderBy: initialPost_ASC/DESC makes the query work. Other orderBy parameters work fine.
- I am using https://graphql-console.subsquid.io/?graphql_api=https://query.joystream.org/graphql to construct my query
Query:
`query MyQuery {
forumThreads(limit: 3000, orderBy: initialPost_ASC) {
author {
handle
id
}
id
initialPostId
}
}`
Error:
`{
"errors": [
{
"message": "column forumthread.undefined does not exist",
"locations": [
{
"line": 2,
"column": 3
}
],
"path": [
"forumThreads"
],
"extensions": {
"code": "INTERNAL_SERVER_ERROR",
"exception": {
"query": "SELECT \"forumthread\".\"id\" AS \"forumthread_id\", \"forumthread\".\"initial_post_id\" AS \"forumthread_initial_post_id\" FROM \"forum_thread\" \"forumthread\" WHERE \"forumthread\".\"deleted_at\" IS NULL ORDER BY \"forumthread\".\"undefined\" ASC LIMIT 3000",
"parameters": [],
"driverError": {
"length": 120,
"name": "error",
"severity": "ERROR",
"code": "42703",
"position": "197",
"file": "parse_relation.c",
"line": "3393",
"routine": "errorMissingColumn"`
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.