Skip to main content

Operator: not_any_of for status columns is not working


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

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

Thank you for that @crushtest !

Our team will take a look into it!


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

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 😀