[rt-users] TicketSQL search for requested tickets of current user?

[Gene LeDuc]

Hi Justin,

I'm pretty sure that Requestor is a group rather than an individual (a 
ticket can have multiple requestors, but only a single owner).  You might 
see if there are any functions that check for group membership in TicketSQL.

Gene

At 06:35 AM 5/1/2007, Justin Hayes wrote:
>Hi,
>
>The customers I support (the Requestors) will be using the At A Glance 
>screen rather than SelfService. I would like to create a saved search that 
>will display tickets requested by the currently logged in user.
>
>I know you can do Owner = '__CurrentUser__' in a search, but is there an 
>equivalent for Requestor?
>
>I've tried Requestor = '__CurrentUser__', Requestor.id, Requestor.Name, 
>Requestor.RealName etc etc but none seem to work. Can't see anything about 
>this on the Wiki so thought I'd ask here.
>
>Thanks in advance for any help!
>
>------------------------------------------------------
>Justin Hayes
>Support Manager
><mailto:justin.hayes at orbisuk.com>justin.hayes at orbisuk.com
>
>
>
>_______________________________________________
>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
>Community help: http://wiki.bestpractical.com
>Commercial support: sales at bestpractical.com
>
>
>Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>Buy a copy at http://rtbook.bestpractical.com


-- 
Gene LeDuc, GSEC
Security Analyst
San Diego State University 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070501/d4734e65/attachment.htm>