Skip to main content

I am trying to write that mutation query but not able to make it work.


the query should select the row based on the environment name and update the columns “remark” and “branch” with the values I will provide in the query.


I found we can update the column value using below query:


mutation {

  change_multiple_column_values(

    item_id: xxxxxxxx

    board_id: 1122334455

    column_values: "{\\"status\\" : {\\"label\\" : \\"Done\\"}, \\"dropdown\\": \\"My label\\" }"

  ) {

    id

  }

}

but in above query I don’t know the item_id. How can I have a query which will find the item_id by matching the column ‘environment’ with ‘test’

Hello there @vrathore and welcome to the community!


I hope you like it here 💪


What would the “environment” be? The item’s name (first column)?


If so, you can use a query like this one:


{

  items_page_by_column_values(

    board_id: 1234567890

    columns: u{column_id: "name", column_values: l"test"]}]

  ) {

    items {

      id

      name

    }

  }

}

I hope that helps!


Cheers,

Matias

@Matias.Monday

Thank you for your assistance, but my objective is to accomplish a different task. I have attached a snapshot for clearer understanding.


What I aim to achieve is to update the ‘Tag’ and ‘Branch’ columns with specific values if the item is labeled as ‘Test’. To accomplish this, I believe I need to write a mutation query that will check the item’s value and then update the corresponding ‘Tag’ and ‘Branch’ columns.

Screenshot 2024-02-14 at 11.34.18 AM

Hello there @vrathore,


You will need the query to get the item ID of the item that has that name, and then you can use a mutation as explained here (example here) to change the column values 😁


Cheers,

Matias

Reply


Terms & ConditionsCookie settings