Connected column values

monday Apps & Developers
,
1

So, I have a simple query

query GetBoardItems{  
  boards(ids: 7144577487) {  
    items_page(limit: 5) {  
      items {  
        name  
        column_values {  
          text
        }  
      }  
    }  
  }  
}

Which provides me with values of 5 lines in a board. Problem is that I receive null where this column is connected with different board.
e.g:

[
    '006',
    null,
    'number',
    '436911',
    '12/40',
    'Open',
    null,
    null,
    '15 transactions per 24 h',
    'photo',
    '',
    'Owner'
  ]

and all those nulls are values from a different board, there are names of employees, and I wanted to filter that data to get only one’s employee line, but since there is no name, I can’t get only that value.
The only thing I found is a linkedPulseId, that gives me some number, but I still couldn’t find how to get the text value of those mirror columns.

2

hi @crushtest

Welcome to the community! I assume you want to get the values for a mirror column (connected to a connect_boards column). To do that you must explicitly request this type of column value with:

query GetBoardItems{  
  boards(ids: 7144577487) {  
    items_page(limit: 5) {  
      items {  
        name  
        column_values {  
          text
        }  
        ... on MirrorValue {
          display_value
        }  
    }  
  }  
}

See also: Mirror. This will display the text value of the mirror column but you can’t filter on this type co column.

3

thank you, but I think you misplaced it. it should be inside the column { }
but, anyway, thank you. it now shows some values, but still not all.
I have also a connected column, but I see now where to watch…
But still this answer from api creates more confusion, since the order of columns now is messed a bit… but anyway, we can work with that.

4

You ar correct, I misplaced it. Below one should also give you the connected itemIds

query GetBoardItems{  
  boards(ids: 7144577487) {  
    items_page(limit: 5) {  
      items {  
        name  
        column_values {  
          text
          ... on MirrorValue {
            display_value
          }
          ... on BoardRelationValue {
            linked_item_ids
            linked_items
          }  
        }  
    }  
  }  
}
6

yes, thank you. I already implemented it.