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

[Ruslan Zakirov]

On Thu, Jul 12, 2012 at 9:43 PM, Richard McMahon <rgm at ast.cam.ac.uk> wrote:
>
> Hi,
>
> 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.

my $queues = RT::Queues->new( RT->SystemUser );
$queues->UnLimit;
while ( my $queue = $queues->Next ) {
    print $queue->Name, "\n";
}

>
> r.
>
>
> 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.
>>
>>> Thanks  Richard
>>
>>
>>
>
> -------------------------------------------------------------------
>  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
> -------------------------------------------------------------------



-- 
Best regards, Ruslan.