Changeset 1777


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

Fix search on NULL value

File:
1 edited

Legend:

Unmodified
Added
Removed

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

    r1776 r1777  
    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 not NULL) }, 
     790                          not in (select okey from %s where attr = ? and (value is NULL or value::text = '')) }, 
    791791                          $base->db->quote_identifier($class->_object_table), 
    792792                          $base->db->quote_identifier( 
Note: See TracChangeset for help on using the changeset viewer.