[rt-users] RT4 ticketSQL search for tickets in queues that I'm watching

[Elliot Finley]

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 <ruz at bestpractical.com> wrote:
> Hi,
>
> QueueCc.id = '__CurrentUser__'
>
> On Fri, Sep 30, 2011 at 10:16 PM, Elliot Finley <efinley.lists at gmail.com> 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.
>