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

[Ruslan Zakirov]

Hi,

lib/RT/Tickets.pm (_Overlay.pm in RT 3.8) has all keywords that can be
used on left hand side of a condition, it easy to find them in the
file.

There are only three special cases for right hand side of a condition:

1) __Bookmarked__ that only can be used in id = '__Bookmarked__' and
id !=  '__Bookmarked__'

2) __CurrentUser__ that can be used in any condition, but only makes
sense with Owner.id, Cc.id, AdminCc.id ...

3) Dates can use special syntax to create conditions with dates
relative to the moment when search is performed. For example Due <
'now'. See wiki for examples and references to all possible values.

I don't remember anything else.

On Fri, Sep 30, 2011 at 11:36 PM, Elliot Finley <efinley.lists at gmail.com> wrote:
> 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.
>>
>



-- 
Best regards, Ruslan.