[rt-users] Users Autocomplete not working 4.0.7?

[Shawn Plummer]

I have fixed the problem by editing $RTHOME/share/html/Helpers/Autocomplete/Users

Anyone with Oracle will probably need to do this:
changed lines 119-120 From

$users->Limit( FIELD => $return, OPERATOR => '!=', VALUE => '' );
$users->Limit( FIELD => $return, OPERATOR => 'IS NOT', VALUE => 'NULL', ENTRYAGGREGATOR => 'AND'  );

To Just:
$users->Limit( FIELD => $return, OPERATOR => 'IS NOT', VALUE => 'NULL' );


- Shawn Plummer
Systems Manager

On Aug 31, 2012, at 9:40 AM, Shawn Plummer <plummer at geneseo.edu> wrote:

> According to this http://thunderguy.com/semicolon/2003/04/26/oracle-empty-string-null/ and the oracle DBA and developers here testing against '' an empty string will not work with oracle.
> 
> Now I will just dig around and pull that query out of the code and I should be good.
> 
> - Shawn Plummer
> Systems Manager
> 
> 
> On Aug 30, 2012, at 10:03 PM, Shawn Plummer <plummer at geneseo.edu> wrote:
> 
>> Running that query returns no results.
>> 
>> I will look into the indexing. I know we run the rt full text indexing command every 15 minutes. As for the database indexes I will have to look into it.
>> 
>> - Shawn Plummer
>> Systems Manager
>> 
>> 
>