Skip to main content

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

  • March 23, 2024
  • 2 replies
  • 114 views

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 replies

basdebruin
  • Community Expert
  • March 24, 2024

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


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • March 25, 2024

Hello @Jtoland919 and welcome to the community!

I hope you like it here 💪

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 😁

Cheers,
Matias