Skip to main content

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?

  • April 17, 2024
  • 3 replies
  • 139 views

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.

3 replies

Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • April 17, 2024

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


  • Author
  • New Participant
  • April 17, 2024

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


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • April 21, 2024

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