3

In QGIS 3.16.9 I would like to find all the locations that have a NULL value. It is for a date field in the field services Drains dataset. I have been searching the use of NULL around various forums.

This is what I have put in so far.

enter image description here

Seems a very straight forward thing to ask, basically I want to show where the Depot team need to visit, and raise a flag to see where they need to visit next to prioritise the work.

Taras
  • 32,823
  • 4
  • 66
  • 137
Matt Sully
  • 144
  • 1
  • 6

1 Answers1

4

The correct syntax for fields with null values is:

"last_date" is null

And the reverse:

"last_date" is not null
BERA
  • 72,339
  • 13
  • 72
  • 161