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

[Justin Hayes]

Thanks Gene

Is there any documentation on what's possible or am I going to have  
to figure this out from code?

The TicketSQL page on the wiki doesn't seem to contain much.....

Cheers,

Justin

------------------------------------------------------
Justin Hayes
Support Manager
justin.hayes at orbisuk.com



On 1 May 2007, at 16:35, Gene LeDuc wrote:

> 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
>> 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/20070502/4e32331a/attachment.htm>