Thank you, that worked great. Is there anywhere that lists all the variables and values that are available to be used in ticketSQL?
On Fri, Sep 30, 2011 at 12:25 PM, Ruslan Zakirov <[email protected]> wrote: > Hi, > > QueueCc.id = '__CurrentUser__' > > On Fri, Sep 30, 2011 at 10:16 PM, Elliot Finley <[email protected]> > wrote: >> I have an installation that is made up of many queues. All queues >> need to be visible to everyone so that they are able to move tickets >> to any queue. But each group is only able to ModifyTicket on their >> own queue (1 or 2 of them). I would like to create a dashboard that >> shows tickets only in the queues that they are CC watchers on. I >> could create a separate dashboard for each group and hard-code the >> relevant queues in them easy enough, but I'm trying to write a single >> system-wide dashboard that keys off of '__CurrentUser__' somehow so >> that: >> >> 1) I only have to write a single query >> 2) I don't have to rewrite any queries if I change queues around >> >> Any help would be appreciated. >> >> Thanks, >> Elliot >> -------- >> RT Training Sessions (http://bestpractical.com/services/training.html) >> * San Francisco, CA, USA October 18 & 19, 2011 >> * Washington DC, USA October 31 & November 1, 2011 >> * Melbourne VIC, Australia November 28 & 29, 2011 >> * Barcelona, Spain November 28 & 29, 2011 >> > > > > -- > Best regards, Ruslan. > -------- RT Training Sessions (http://bestpractical.com/services/training.html) * San Francisco, CA, USA October 18 & 19, 2011 * Washington DC, USA October 31 & November 1, 2011 * Melbourne VIC, Australia November 28 & 29, 2011 * Barcelona, Spain November 28 & 29, 2011
