From cd87f9636524f797e22386e9dd6904786991bb43 Mon Sep 17 00:00:00 2001
From: KarinG <karin@semper-it.com>
Date: Fri, 22 Apr 2016 09:12:15 -0600
Subject: [PATCH] CRM-18463 - Not in between filter - not working properly.

---
 CRM/Report/Form.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/CRM/Report/Form.php b/CRM/Report/Form.php
index f720104a49..4fd3eb2ea6 100644
--- a/CRM/Report/Form.php
+++ b/CRM/Report/Form.php
@@ -1783,7 +1783,7 @@ class CRM_Report_Form extends CRM_Core_Form {
               $clauses[] = "( {$field['dbAlias']} >= $min )";
             }
             else {
-              $clauses[] = "( {$field['dbAlias']} < $min )";
+              $clauses[] = "( {$field['dbAlias']} < $min OR {$field['dbAlias']} IS NULL )";
             }
           }
           if ($max) {
@@ -1800,7 +1800,7 @@ class CRM_Report_Form extends CRM_Core_Form {
               $clause = implode(' AND ', $clauses);
             }
             else {
-              $clause = implode(' OR ', $clauses);
+              $clause = '(' . implode('OR', $clauses) . ')';
             }
           }
         }
-- 
2.25.1