[Trac-tickets] Re: [The Trac Project] #879: Allow querying by empty values on Advanced Query screen

[The Trac Project]

#879: Allow querying by empty values on Advanced Query screen
---------------------------+------------------------------------------------
       Id:  879            |      Status:  assigned                
Component:  ticket system  |    Modified:  Mon Nov  8 09:55:46 2004
 Severity:  normal         |   Milestone:  0.9                     
 Priority:  normal         |     Version:  devel                   
    Owner:  cmlenz         |    Reporter:  pkou <pkou at ua.fm>    
---------------------------+------------------------------------------------
Comment (by pkou <pkou at ua.fm>):

 The most important in the patch is SQL statements that are used for
 querying empty values:
  * Standard fields:
 {{{
 SELECT id
 FROM ticket
 WHERE IFNULL(<ticket_field>, '') = ''
 }}}
  * Custom fields:
 {{{
 SELECT id
 FROM ticket
 LEFT OUTER JOIN ticket_custom ON id = ticket
 WHERE name = '<custom-field-id>' AND IFNULL(value, '') = ''
       OR id NOT IN (SELECT ticket
                     FROM ticket_custom
                     WHERE name = '<custom-field-id>')
 }}}

-- 
Ticket URL: <http://projects.edgewall.com/trac/ticket/879>
The Trac Project <>