Query items_page_by_column_values to return only specific columns

monday Apps & Developers
1

Hey all,

With the new API out, I’m swapping my queries and can’t figure out how to return only the column “email_address” from a items_page_by_column_values query. Any ideas?

Original query:
query {items_by_column_values (board_id: 12345, column_id: “status_199”, column_value: “Ready”) {id name column_values(ids:[“email_address”]){text}}}

new query:
query{items_page_by_column_values (limit: 100, board_id: 12345, columns:[{column_id: “status_199”, column_values: [“Ready”]}]){cursor items {id name}}}

2

Hello there @Meneghini,

You can use a query like this one:

{
  items_page_by_column_values(
    limit: 100
    board_id: 1234567890
    columns: [{column_id: "status", column_values: ["Done"]}]
  ) {
    cursor
    items {
      id
      name
      column_values(ids: "connect_boards0") {
        value
        ... on BoardRelationValue {
          display_value
        }
      }
    }
  }
}

I hope that helps!

Cheers,
Matias

1 Like
3

Hey Matias,

Nice to talk to you again. This is exactly what I was looking for. Thanks for your help and the quick response!

1 Like
4

I am glad to hear that @Meneghini !!

Happy to help!

1 Like