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
>
>
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
