[rt-users] Cannot search by requestor

[Robie Basak]

Hi, 

Searching by requestor seems to always return no results. I'm using RT
2.0.13 and on a remote postgres. 

I found someone saying something similar in the archives and tried to
upgrade DBIx::SearchBuilder accordingly (I'm using Debian Woody, so
first I purged the package libdbix-searchbuilder-perl and then installed
0.61 from source, then restarted apache-perl) but this didn't seem to
help. 

I put: 
  use Data::Dumper; 
  print Dumper (\%args); 
in Limit() in RT/EasySearch.pm and the result is attached. Is the query
correct at that stage?

Here's the postgres log:
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: SELECT DISTINCT main.* FROM Tickets main, Watchers Watchers_1 
LEFT JOIN Users as Users_2  ON  Watchers_1.Owner = Users_2.id  WHERE
((main.EffectiveId = main.id)) AND ((Watchers_1.Scope = 'Ticket')) AND
((main.id = '1')) AND ((Watchers_1.Type = 'Requestor')) AND
((lower(Watchers_1.Email) =
'robie at principle.co.uk')OR(lower(Users_2.EmailAddress) =
'robie at principle.co.uk'))  AND main.id = Watchers_1.Value  
ERROR:  parser: parse error at or near "left"
AbortCurrentTransaction

Robie.
-------------- next part --------------
Script started on Fri Jul 19 08:55:45 2002
$ ./rt --id=1- --summary --limit-requestor=robie at principle.co.uk
  id  Stat    Queue                                   Subject         Requestor 
$VAR1 = {
          'VALUE' => '1',
          'FIELD' => 'id',
          'ENTRYAGGREGATOR' => 'AND',
          'OPERATOR' => '>=',
          'CASESENSITIVE' => 1
        };
$VAR1 = {
          'VALUE' => 'Ticket',
          'FIELD' => 'Scope',
          'ALIAS' => 'Watchers_1',
          'OPERATOR' => '=',
          'CASESENSITIVE' => 1
        };
$VAR1 = {
          'VALUE' => 'robie at principle.co.uk',
          'FIELD' => 'Email',
          'ALIAS' => 'Watchers_1',
          'ENTRYAGGREGATOR' => 'OR',
          'SUBCLAUSE' => 'WatcherEmailAddress',
          'OPERATOR' => '=',
          'CASESENSITIVE' => 0
        };
$VAR1 = {
          'VALUE' => 'robie at principle.co.uk',
          'FIELD' => 'EmailAddress',
          'ALIAS' => 'Users_2',
          'ENTRYAGGREGATOR' => 'OR',
          'SUBCLAUSE' => 'WatcherEmailAddress',
          'OPERATOR' => '=',
          'CASESENSITIVE' => 0
        };
$VAR1 = {
          'VALUE' => 'Requestor',
          'FIELD' => 'Type',
          'ALIAS' => 'Watchers_1',
          'ENTRYAGGREGATOR' => 'OR',
          'OPERATOR' => '=',
          'CASESENSITIVE' => 1
        };
$VAR1 = {
          'VALUE' => 'main.id',
          'FIELD' => 'EffectiveId',
          'OPERATOR' => '=',
          'CASESENSITIVE' => 1,
          'QUOTEVALUE' => 0
        };

Script done on Fri Jul 19 08:57:48 2002