diff options
Diffstat (limited to 'rt/share/html/Helpers/Autocomplete/Users')
-rw-r--r-- | rt/share/html/Helpers/Autocomplete/Users | 22 |
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 |