Skip to main content

Monday Api : select items in board where last updated user is not me

  • October 28, 2024
  • 1 reply
  • 16 views

Hello here,

I would like to collect items from the board if the last user who modified the item is not myself.
I use a user type column named “pulse_updated” to check the last updated date and user from each item.

According to the results, the query doesn’t work. Some items were updated by myself and they shouldn’t be selected by this query.

my query :

query {
  boards(ids: XXXXXXX) {
    items_page(query_params: {
      rules: [{
        column_id: "pulse_updated", 
        compare_value: ["assigned_to_me"], 
        operator:not_any_of,
        compare_attribute:"UPDATED_AT"
      }]
    }) {
      items {
        id
        name
        column_values (ids:"pulse_updated") {
          id
          text
          value
          ... on LastUpdatedValue {
            updated_at
            value
            updater {
              name
            }
          }
        }
      }
    }
  }
}

I suspect that the operator “not_any_of” has an anomaly when we use the person’s id filter on the user type column. In reverse, operator “any_of” has good behavior.

1 reply

OmerK
Forum|alt.badge.img+1
  • monday.com Team Member
  • October 31, 2024

Hey @hugo.vanbeversluys , welcome to the community!
Could you please open a support ticket so our team can investigate more deeply?