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.
pgpSi6j4Ufof1.pgp
Description: PGP signature