Filtering for null table fields

Dev Support
1

I’m using filter for lots of other things without problems, but now I would like to filter for rows where a (1:1) table field is null.

The query below these results show that there are rows with “null”. But if I try to filter for them I don’t get any results.

{
  "data": {
    "storiesList": {
      "items": [
        {
          "title": "Basic task fields are configured",
          "sprint": null
        },

And here’s the query:

{
  storiesList(filter: {
    # sprint: {
    #   id: {
    #     equals: null
    #   }
    # }
  }) {
    items {
      title
      sprint {
        id
      }
    }
  }
}

How do you query for null fields?

2 
{
  storiesList(filter: {
     sprint: null
  }) {
    items {
      title
      sprint {
        id
      }
    }
  }
}
1 Like
3

I knew it was something simple, I just got used to adding the {} all the time for fields.

Thanks!

1 Like