summaryrefslogtreecommitdiff
path: root/rt/share/html/Helpers/Autocomplete/Users
diff options
context:
space:
mode:
Diffstat (limited to 'rt/share/html/Helpers/Autocomplete/Users')
-rw-r--r--rt/share/html/Helpers/Autocomplete/Users22
1 files changed, 18 insertions, 4 deletions
diff --git a/rt/share/html/Helpers/Autocomplete/Users b/rt/share/html/Helpers/Autocomplete/Users
index c2b92c1bf..349442a4f 100644
--- a/rt/share/html/Helpers/Autocomplete/Users
+++ b/rt/share/html/Helpers/Autocomplete/Users
@@ -2,7 +2,7 @@
%#
%# COPYRIGHT:
%#
-%# This software is Copyright (c) 1996-2012 Best Practical Solutions, LLC
+%# This software is Copyright (c) 1996-2013 Best Practical Solutions, LLC
%# <sales@bestpractical.com>
%#
%# (Except where explicitly superseded by other copyright notices)
@@ -111,13 +111,27 @@ while (my ($name, $op) = each %fields) {
# Exclude users we don't want
foreach (split /\s*,\s*/, $exclude) {
- $users->Limit(FIELD => 'id', VALUE => $_, OPERATOR => '!=');
+ $users->Limit(FIELD => 'id', VALUE => $_, OPERATOR => '!=', ENTRYAGGREGATOR => 'AND');
}
my @suggestions;
-$users->Limit( FIELD => $return, OPERATOR => '!=', VALUE => '' );
-$users->Limit( FIELD => $return, OPERATOR => 'IS NOT', VALUE => 'NULL', ENTRYAGGREGATOR => 'AND' );
+if ( RT->Config->Get('DatabaseType') eq 'Oracle' ) {
+ $users->Limit(
+ FIELD => $return,
+ OPERATOR => 'IS NOT',
+ VALUE => 'NULL',
+ );
+}
+else {
+ $users->Limit( FIELD => $return, OPERATOR => '!=', VALUE => '' );
+ $users->Limit(
+ FIELD => $return,
+ OPERATOR => 'IS NOT',
+ VALUE => 'NULL',
+ ENTRYAGGREGATOR => 'AND'
+ );
+}
while ( my $user = $users->Next ) {
next if $user->id == RT->SystemUser->id