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 <[email protected]> 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 <[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. >> > -- 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
