Ignore:
Timestamp:
05/31/16 09:54:27 (8 years ago)
Author:
nanardon
Message:

Really fix search on NULL value

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/objects.pm

    r1777 r1778  
    788788            if ($mode eq '=' && $val eq 'NULL') { 
    789789                $sql = sprintf(q{ select ikey from %s where ikey 
    790                           not in (select okey from %s where attr = ? and (value is NULL or value::text = '')) }, 
     790                          not in (select okey from %s where attr = ? and ("value" is NOT NULL and value != '')) }, 
    791791                          $base->db->quote_identifier($class->_object_table), 
    792792                          $base->db->quote_identifier( 
Note: See TracChangeset for help on using the changeset viewer.