Reading values for a row based on the value of a column

monday Apps & Developers
, ,
1

New to graphql i need to read all the values for a given row based on the value of a particular column. Please point me in the right direction

2

That depends of the column type for the “particular” column

3

Hello @Jtoland919 and welcome to the community!

I hope you like it here :muscle:

As @basdebruin mentioned, depending on the column type, the format will be different.

Examples:

Get all items that have a specific text in a “text” column:

{
  items_page_by_column_values(
    limit: 500
    board_id: 1234567890
    columns: [{column_id: "text", column_values: ["Some text"]}]
  ) {
    items {
      id
      name
    }
  }
}

Get all items that have an unchecked checkbox column:

{
  items_page_by_column_values(
    limit: 500
    board_id: 1234567890
    columns: [{column_id: "checkbox", column_values: [null]}]
  ) {
    items {
      id
      name
    }
  }
}

You can check the syntax for each column type here :grin:

Cheers,
Matias