When using the … on MirrorValue fragment the property you are looking for is called display_text not just text. This is also the case for other fragments.
Thank you very much
.
Do you meant change
… on MirrorValue {
display_text
column {
id
title
}
And how about the first question if I set condition in column value
Actually it is display_value, not display_text, sorry for the confusion. As for the conditions, see Other types and the specifics for filtering a number column here Numbers
The total query looks like this:
query {
boards(ids: [18084084XX]) {
groups (ids: ["new_group269XX"]){
title
items_page (query_params: {rules: [{column_id: "numbers", compare_value: [2500], operator:greater_than}, {column_id: "numbers", compare_value: [3000], operator:lower_than}]}){
items {
id
column_values {
id
text
column {
title
}
... on BoardRelationValue {
linked_items {
id
name
}
}
... on MirrorValue {
display_value
column {
id
title
}
id
}
}
}
}
}
}
}
I recommend to play around in the API Playground. It is designed to play around 🙂
Thank you very much
query {
boards(ids: [18084084xx]) {
groups(ids: ["new_group269xx"]) {
title
items_page (query_params: {rules: [{column_id: "property_id", compare_value: ["26d090f1-8ad6-Ac35-8a62-fc9e38b81ec5","9853c253-1b2c-Ada7-97f4-33b7d6f7a14c","19768d04-b806-Abf3-b7cc-ec43722e1a48"]}]})
{
items {
id
column_values {
id
text
column {
title
}
... on BoardRelationValue {
linked_items {
id
name
}
}
... on MirrorValue {
display_value
column {
id
title
}
id
}
}
}
}
}
}
}
and get proper items already
but please advise more if we should have more condition such as … and…, …or…, …nor…
how to modify query_params rule?
Everything is in the docs, I suggest you play around in the API Playground. The query_params accepts an operator that can be either and or or.
Hi Bas, is it possible to read a number value in a mirror column?
I’ve tried this query:
query {
items (ids:s1234567890]) {
column_values {
... on MirrorValue {
display_value
id
}
}
}
}```
and it returns empty value for any mirror that contains numbers, for example subitems total column:
{
“data”: {
“items”: i
{
“column_values”: m
{},
{
“display_value”: “”,
“id”: “subitems_total”
},
{},
{}
]
}
]
},
“account_id”: 12345678
}
Thank you!
It is possible to get an array of all numbers in the mirror column making up the total. In this query
{
items(ids: 123456789) {
column_values (ids: "subitems_numbers") {
id
value
... on MirrorValue {
display_value
}
}
}
}
the display value shows
{
"data": {
"items": [
{
"column_values": [
{
"id": "subitems_numbers",
"value": null,
"display_value": "8, 7, 60, 7, 8, 2, 4, 3, 10, 2, 3, 4, 6, 7, 7, 8, 9, 5, 1, 2, 3, 4, 6, 7, 7, 8, 9, 5, 1, 2, 3, 4, 6, 7, 7, 8, 9, 5"
}
]
}
]
},
"account_id": 123456
}
