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

2007-05-03 Thread Justin Hayes
hmm thanks for trying though Gene - much appreciated. I've written a few custom At a Glance modules to show open tickets by requestor, owner and priority grouped, as it appears you can't do aggregate columns in the query builder? So for example I get a little box on the At a Glance screen

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

2007-05-02 Thread 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 [EMAIL

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

2007-05-01 Thread Justin Hayes
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