RT4 ticketSQL search for tickets in queues that I'm watching

RT Users
1

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

2

Hi,

QueueCc.id = 'CurrentUser’On Fri, Sep 30, 2011 at 10:16 PM, Elliot Finley efinley.lists@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.

3

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@bestpractical.com wrote:

Hi,

QueueCc.id = ‘CurrentUser’

On Fri, Sep 30, 2011 at 10:16 PM, Elliot Finley efinley.lists@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.

4

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@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@bestpractical.com wrote:

Hi,

QueueCc.id = ‘CurrentUser’

On Fri, Sep 30, 2011 at 10:16 PM, Elliot Finley efinley.lists@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.