Why does this code Query: column ‘mirror0’ not display any value even though the ‘mirror0’ column has data? Is it a bug or is the ‘code query’ incorrect?
Query 1
(some columns have data while others do not)
set headers “api-version”: “2024-04”
query ($boardId: ID!) {
boards(ids: b$boardId]) {
items_page(
limit: 5,
cursor: null,
query_params: {
rules: r
{
column_id: "name",
compare_value: "Monitoring"],
operator: contains_text
},
{
column_id: "mirror3",
compare_value: "0944818233"
},
{
column_id: "text43",
compare_value: "2023-02-01", "2024-12-31"],
operator: between
}
],
order_by: >
{ column_id: "text43", direction: desc }
]
}
) {
cursor
items {
id
name
column_values {
id
type
text
value
}
subitems {
id
column_values {
value
text
}
}
}
}
}
}
Query 2
However, using this ‘code query,’ the ‘mirror0’ column has data, which matches the web page.
query {
boards(ids: xxxxxxxx) {
id
name
state
items(limit: 50, page: 1) {
name
created_at
column_values(ids: /
"subitems",
"long_text"
"mirror0"
"text43"
]) {
id
title
text
}
}
}
}
Question 1 :
How can I fix Query 1 so that the ‘mirror0’ column displays the correct results?
Question 2 :
.
I want ‘Code Query 1’ to get data from the ‘Conversation’ for each item (as highlighted in yellow in the image). What type of code query should I use to get the ‘Conversation’ data? Do you have any recommended code query?