Search for field one equal to field two

RT Users
1

I have an RT system running on Debian Stable (RT from the debian repo).

I would like to have that follows the logic below - but when I tried it
in the “Advance search” option, I had errors - so my guess is I am
missing something and/or don’t correctly understand how things work.
(my Perl and PostSQL skills come down to copy/paste with a bit of
guesstimating)

Is what I am thinking even possible? Any help with pointers/reading
material will also be appreciated.

Queue = ‘HelpDesk’
AND LastUpdatedBy = Requestor.EmailAddress
AND LastUpdated > Created

http://gentgeen.homelinux.org

Associate yourself with men of good quality if you esteem
your own reputation; for 'tis better to be alone then in bad
company. - George Washington, Rules of Civility

2

Kevin,

I believe you are trying to compare fields that are not defined the

same. LastUpdatedBy is a numeric field and contains the ID of the user,
not the email address. The numeric field will not compare to a character
field. Two different types of data. You need to take the UserID from
“LastUPdatedBy” and get the emailaddress of that user and then compare
it to the Requestor Emailaddress. The LastUpdated IS the same type as
Created, so that compare is OK. Hope this helps.

Kenn
LBNLOn 9/10/2008 5:39 AM, Kevin Squire wrote:

I have an RT system running on Debian Stable (RT from the debian repo).

I would like to have that follows the logic below - but when I tried it
in the “Advance search” option, I had errors - so my guess is I am
missing something and/or don’t correctly understand how things work.
(my Perl and PostSQL skills come down to copy/paste with a bit of
guesstimating)

Is what I am thinking even possible? Any help with pointers/reading
material will also be appreciated.

Queue = ‘HelpDesk’
AND LastUpdatedBy = Requestor.EmailAddress
AND LastUpdated > Created