From: mark <mark>
Date: Fri, 30 Dec 2011 22:12:01 +0000 (+0000)
Subject: improve behavior of != operator
X-Git-Tag: freeside_2_3_1~42
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=d5109b4395d35a615f36fc7629803c24d489c516

improve behavior of != operator
---

diff --git a/FS/FS/Record.pm b/FS/FS/Record.pm
index 126b0cb31..a9d15cb25 100644
--- a/FS/FS/Record.pm
+++ b/FS/FS/Record.pm
@@ -662,6 +662,8 @@ sub get_real_fields {
             qq-( $column $op "" )-;
           }
         }
+      } elsif ( $op eq '!=' ) {
+        qq-( $column IS NULL OR $column != ? )-;
       #if this needs to be re-enabled, it needs to use a custom op like
       #"APPROX=" or something (better name?, not '=', to avoid affecting other
       # searches