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
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:
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
‘email@example.com’)) AND main.id = Watchers_1.Value
ERROR: parser: parse error at or near "left"
typescript (1.5 KB)