OK, that gets me the queue list.
Is there an API way to get the full list of valid status values and also
the list of names of ticket owners. I have looked that the code
that Ruslan mentions but I am able see how to get at the owner
list and list of valid status values.
thanks
I know how to this sort of thing with RAW SQL but prefer to try to
use the API.
I have looked at QueueSummaryByStatus in RT4 but
thanks
On Thu, 12 Jul 2012, Kevin Falcone wrote:
Date: Thu, 12 Jul 2012 15:00:00 -0400
From: Kevin Falcone <falc...@bestpractical.com>
Reply-To: rt-users@lists.bestpractical.com
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Perl API: list of available queues, owners, status
On Thu, Jul 12, 2012 at 07:43:16PM +0100, Richard McMahon wrote:
I am doing some ASCII perl reports and one of the options is to supply
the queue name. I want to be able to get a list of the queues that
are available as an input check.
In that case, it's probably easier to ->Load the queue by name and see
if it exists, rather than list 20 queues and name compare each.
-kevin
On Thu, 12 Jul 2012, Ruslan Zakirov wrote:
Date: Thu, 12 Jul 2012 21:30:15 +0300
From: Ruslan Zakirov <r...@bestpractical.com>
To: Richard McMahon <r...@ast.cam.ac.uk>
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Perl API: list of available queues, owners, status
On Thu, Jul 12, 2012 at 7:58 PM, Richard McMahon <r...@ast.cam.ac.uk> wrote:
Hello,
Is there a way/example of how to get a list of queues, owners, status using
the Perl API?
I want to cycle through making a list counts for each owner
and queue by status.
You want count tickets groupped by queue, owner and status, right? You
really don't want to iterate over anything. It will be very slow.
Instead take a look at how QueueSummaryBy* files do it in RT 4.0 and
how RT::Extension::SummaryByUser (on CPAN) does similar task. You just
need to combine two tables into one big table.
-------------------------------------------------------------------
Dr. Richard G. McMahon | Phone (office) 44-(0)-1223-337519
University of Cambridge | (switchboard) 1223-337548
Institute of Astronomy | (secretary) 1223-337516
Madingley Rd | FAX 1223-337523
Cambridge, CB3 OHA, UK. | mobile 7885-409019
Office: Hoyle 18 | home 1223-359770
-------------------------------------------------------------------
email: r...@ast.cam.ac.uk | WWW: http://www.ast.cam.ac.uk/~rgm
richardgmcma...@gmail.com | skype: richardgmcmahon
-------------------------------------------------------------------
