Ticket #2974 (closed enhancement: fixed)
Search for NULL value seemignly not possible from simple search and not obvious from advanced search
|Reported by:||Elgon||Owned by:||kcube|
|Priority:||minor: annoyance||Milestone:||Version 1.6.0|
|Platform Version:||Windows 7||Platform:||Debian|
|Must Fix for Release:||Yes||Awaiting user input:||no|
In the release notes for QGIS 1.5.0 it says "Support NULL values in search strings". However, a search for NULL,"", ,"NULL" in the "Look for" box does not yield any results. It is possible to search for NULL in advanced search with the syntax Field IS NULL. This however is also not obvious as "IS" does not seem to be an optional operator within the Search Query Builder.
AS the NULL value can occur often in data and can be seen in the attribute table but cannot be searched for in an easy way like all other values, I plead for a an equal treatment of NULL in this respect.
Suggestions: 1. Enable the search for NULL in the simple search. 2. Enable search with the syntax "Field = NULL" in the Advanced search. (I believe introducing "IS" as a new operator does not make much sense as it is logically the same as "=".)