[rt-users] SimpleSearch returning all users

[Woody - Wild Thing Safaris]

Hi all,

I've created a scrip who's objective is to search users on create to 
find one with a matching domain and CF.Consultant set, but the 
SimpleSearch returns all users

       my $Users = RT::Users->new($RT::SystemUser);
      $Users->SimpleSearch(
          Term => $Domain,
#         Return => 'CF.Consultant'
      );


I have
     Set($UserSearchFields, {
         EmailAddress => 'LIKE',
         Name         => 'STARTSWITH',
         RealName     => 'LIKE',
     });


I hashed out CF.Consultant as it gives the error

[642] [Sat Sep 10 05:35:24 2016] [critical]: Possible SQL injection 
attack: CF.Consultant != 
(/var/www/sm-rt/sbin/../lib/RT/SearchBuilder.pm:898)
[642] [Sat Sep 10 05:35:24 2016] [critical]: Possible SQL injection 
attack: CF.Consultant IS NOT 
(/var/www/sm-rt/sbin/../lib/RT/SearchBuilder.pm:898)

thanks in advance

Woody.

-- 

-----------------------

Richard Wood (Woody)
Managing Director
Wild Thing Safaris Ltd.

UK: 2B Habbo St, Greenwich, London
Dar es Salaam: 5 Ethan St, Mbezi beach
Arusha: 3 Ebeneezer Rd, Njiro
PO BOX 34514 DSM
Office: +255 (0) 222 617 166
Office Mobile: +255 (0) 773 503 502
Direct: +255 742 373 327
Skype: woody1tz
http://wildthingsafaris.com