How do I query items_by_column_values where the value is null (None)?

monday Apps & Developers Feature Requests - API and Apps Framework
1

How do I query items_by_column_values where the value is null (None)?
In particular, I am interested in column types of status and link.

query {
  items_by_column_values(
    board_id: 1234567890,
    column_id: "status",
    column_value: "null"
  )
  {
    id
    name
    column_values {
      id
      text
      value
    }
  }
}
2 Likes
2

Hey @sillywilly – welcome to the community :wave:

At the moment there isn’t a way to query an empty value on that particular operation, but I’ve passed this feedback along to our dev team so we can review it in a future iteration.

Thanks a lot!

1 Like
3

+1

This would be great and make sense!

4

The workaround is to create bogus data and search on that.

It should be native.

5

Hi all, Has the problem of retrieving items where the value of a certain column is null been resolved from 2019 to today?

6

Hi @jackalope,

This is currently not supported by our API. Could you share more on your use case for this feature? I’d like to understand your need and pass this along to our team.

7

The final goal (which is similar to what I indicated in the other thread) is to be able to notify the person who owns a certain item for which one or more columns are empty to remind him to fill them.

8

Thanks for sharing this @jackalope! This will help our team understand what is missing from our current features.

1 Like
10

Hi @alessandra ,

We have an enterprise monday subscription and we have been waiting for this feature about 1 year as well. Do you have any eta on this?

Thanks for your support.

11

Hi @mehmet,

Thanks for your feedback! While we don’t have an ETA for this feature, I’ve added your vote to this request to let our team know of your interest.

12

Hi

In version 2023-10 it now allows to filter by null value.

Happy programming!