[rt-users] Search for field one equal to field two
Kenneth Crocker
KFCrocker at lbl.gov
Wed Sep 10 13:42:18 EDT 2008
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
LBNL
On 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
>
>
More information about the rt-users
mailing list