I already asked about this topic, but I am still struggling. I created a geopackage with railways of Germany. I need to filter some sections out. I understand that geopackages work with SQL syntax for filtering. But when I use syntax I looked up, QGIS is not doing what its supposed to do.

enter image description here

I just want the railways without the tunnels. I used "tunnel" IS NULL;.

It is successful. No warning is displayed, but all the railways are gone. I use the filter function of the layer. no the query builder. enter image description here

What do I have to change?

  • 1
    If the test is successful then the features should appear also on the map, but try if "tunnel" NOT LIKE 'yes' makes any difference.
    – user30184
    Aug 2, 2022 at 11:29

1 Answer 1


It sounds like a bug.

If you enter "tunnel" IS NULL;, with an ending ;, and click the test button, it will show the number of features that should be found, but QGIS won't display them

If you remove the ending ;, then everything works fine.

PS: I see this under 3.16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.