[QGIS-trac] [Quantum GIS] #2974: Search for NULL value seemignly not possible from simple search and not obvious from advanced search

[Quantum GIS]

#2974: Search for NULL value seemignly not possible from simple search and not
obvious from advanced search
------------------------------------------------+---------------------------
   Reporter:  Elgon                             |              Owner:  nobody       
       Type:  bug                               |             Status:  new          
   Priority:  major: does not work as expected  |          Milestone:  Version 1.6.0
  Component:  Build/Install                     |            Version:               
   Keywords:  NULL search                       |   Platform_version:  Windows 7    
   Platform:  Debian                            |           Must_fix:  Yes          
Status_info:  0                                 |  
------------------------------------------------+---------------------------
 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 "=".)

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/2974>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats