[rt-users] Perl API: list of available queues, owners, status

[Kevin Falcone]

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 <falcone at bestpractical.com>
> >Reply-To: rt-users at lists.bestpractical.com
> >To: rt-users at 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 <ruz at bestpractical.com>
> >>>To: Richard McMahon <rgm at ast.cam.ac.uk>
> >>>Cc: rt-users at 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 <rgm at 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: rgm at ast.cam.ac.uk  | WWW:    http://www.ast.cam.ac.uk/~rgm
>  richardgmcmahon at gmail.com | skype:                richardgmcmahon
> -------------------------------------------------------------------
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120712/5c3b1616/attachment.sig>