Finds all items in which a specific column has a specific value

monday Apps & Developers
, ,
4

Hi @jackalope

I think your best option for this would be using the items_by_column_values query - Items By Column Values

This will allow you to get all items based on the status (or another column if you prefer), you can then loop through the returned items and filter based on your other column values.

A query like this would work:

query {
    items_by_column_values (board_id: 1234567, column_id: "status5", column_value:"YES") {
        id
        name
        column_values (ids: ["person", "status", "date4"]){
             id
             text
             value
       }
    }
}

Currently you can only search based on a single column.

1 Like