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 <[email protected]> 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 <[email protected]> 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 >> >> >
