Update QueryGenerator.php

Does Not Contain (operator k) must allow for NULL values as well as NOT LIKE values (e.g. in multipicklist). FIXES error as stated at: #1682 (closed)

include/QueryGenerator/QueryGenerator.php

@@ -1037,6 +1037,10 @@ class QueryGenerator {
$sql[] = sprintf("IS NOT NULL AND %s != ''", $this->getSQLColumn($field->getFieldName(), $field));
continue;
}
+			if ($operator == 'k') {
+				$sql[] = sprintf("IS NULL OR %s NOT LIKE '%%%s%%'", $this->getSQLColumn($field->getFieldName(), $field), $value);
+				continue;
+			}
if((strtolower(trim($value)) == 'null') ||
(trim($value) == '' && !$this->isStringType($field->getFieldDataType())) &&
($operator == 'e' || $operator == 'n')) {
@@ -1126,9 +1130,6 @@ class QueryGenerator {
case 'c': $sqlOperator = "LIKE";
$value = "%$value%";
break;
-				case 'k': $sqlOperator = "NOT LIKE";
-					$value = "%$value%";
-					break;
case 'l': $sqlOperator = "<";
break;
case 'g': $sqlOperator = ">";