How to search for updated Monday column values AND which matches a status? Also how to increase the limit in how many column values to retreieve?

monday Apps & Developers
, , , , ,
1

Hi, I am able to search monday column values via API which were updated Today. This is working fine.

Now i want to add a filter. Only retrieve those updated values which were updated today AND matches a status, How to add this filter? Also How to increase the limit in column values? Currently only 25 column values are coming via API.

2

Hello there @jayesh_da,

I am not sure I understand the use case.

Do you want to get all items that have had at least one change in their column values today and that have a specific value in a status column?

Is that the goal?

Regarding the limit, you can add a “limit” argument to your “items_page” object.

Looking forward to hearing from you!

Cheers,
Matias

3

Hey @Matias.Monday ,

Yes you are right. I want to get all items that have had at least one change in their column values today and that have a specific value in a status column

4

Hello again @jayesh_da,

What if you use something like this:

{
  boards(ids: 1234567890) {
    items_page(
      query_params: {rules: [{column_id: "status", compare_value: [2], operator: any_of}, {column_id: "__last_updated__", compare_value: ["YESTERDAY"], compare_attribute: "UPDATED_AT", operator: greater_than}]}
    ) {
      cursor
      items {
        id
        name
      }
    }
  }
}

Note: You would not need a “last updated” column for this. And 2 would be the index of one of the labels in the status column.

Looking forward to hearing from you!

Cheers,
Matias