On Fri, Jul 13, 2012 at 01:01:05AM +0100, Richard McMahon wrote: > Is there an API way to get the full list of valid status values and also
Have you tried running perldoc /opt/rt4/lib/RT/Queue.pm and searching for Status? > the list of names of ticket owners. I have looked that the code Look at what the SelectOwner template does to get an owner list. -kevin > 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 > -------------------------------------------------------------------
pgp3ADpFooG5h.pgp
Description: PGP signature