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

improve behavior of != operator
---

diff --git a/FS/FS/Record.pm b/FS/FS/Record.pm
index 677348728..598cb6a77 100644
--- a/FS/FS/Record.pm
+++ b/FS/FS/Record.pm
@@ -577,6 +577,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