Skip to main content

Operator: not_any_of for status columns is not working

  • October 24, 2024
  • 6 replies
  • 40 views

here’s my request:

query {
boards(ids: [BOARDID]) {
items_page(
limit: 1,
query_params: {
rules: [{
column_id: “status21__1”,
compare_value: [“UNPAID”],
operator: not_any_of
}],
operator: and
}
) {
items {
id
name
}
}
}
}
What I want to get is all items that don’t have specific status, but whatever details I write in compare_value I receve the same item. the item have ‘PAID’ status, so if I write there PAID not_any_of it anyway returns me the same answer.

To get more specific - I get that from the playground, so it’s not issue on my side.

6 replies

rachelatmonday
Forum|alt.badge.img
  • monday.com Team Member
  • October 30, 2024

Hi @crushtest,

Would you be able to open a ticket here? Our team can take a look at your query and help you get the data you need!

Best,
Rachel


  • Author
  • New Participant
  • November 6, 2024

opened ticket, thanks


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • November 6, 2024

Thank you for that @crushtest !

Our team will take a look into it!


  • New Participant
  • January 10, 2025

This was solved? I’m facing the some problem


  • Author
  • New Participant
  • January 10, 2025

It was solved. But like two days ago it started again. I took not_any_of one status, and it showed me items with that status as well. IDK how and why


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • January 12, 2025

Hello everyone!

If you experience any issues with this now, please fill this form adding as much information as possible to it so that our team can take a look into it, in case you have not created a ticket yet. If you already have an email thread with us, please continue using that thread to work on this with our support team 😀