[rt-users] Reporting: List of new/open tickets?

[Kimberly McKinnis]

I guess I should be more specific. Our PMs would like to have this info automated and emailed, instead of cutting and pasting it from the query builder in RT. Thanks!

-----Original Message-----
From: Ruslan Zakirov [mailto:ruslan.zakirov at gmail.com] 
Sent: Thursday, August 27, 2009 3:10 PM
To: Kimberly McKinnis
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Reporting: List of new/open tickets?

Hello Kimberly,

Do you need script? In the RT web ui you can use Charts for that. As
well, you can re-use code from the latest version of
share/html/Search/Elements/Chart


my $Query = "Queue = 'X'";

use RT::Report::Tickets;
my $tix = RT::Report::Tickets->new( $session{'CurrentUser'} );
my ($count_name, $value_name) = $tix->SetupGroupings(
    Query => $Query, GroupBy => 'Status',
);
while ( my $entry = $tix->Next ) {
    my $status = $entry->__Value( $value_name );
    my $count = $entry->__Value( $count_name );
    print "$status => $count\n";
}

I think this code should work, but I'm not sure if SetupGroupings
method is part of RT 3.8.4 or not. Implemented it recently to simplify
things and make it possible to group by multiple columns.

On Fri, Aug 28, 2009 at 1:42 AM, Kimberly McKinnis<kmckinnis at tivo.com> wrote:
> Before I attempt to reinvent the wheel, I was wondering if anyone had
> written a reporting script that did something such as listing the numbers
> and subjects of all open and new tickets. I found something on the wiki, but
> it requires manual input of ticket numbers.
>
>
>
> I also have some rudimentary scripting using the RT pms, but any
> pre-existing code would save time. Thanks!
>
>
>
> ~~
>
> Kimberly McKinnis
>
> System Operations Engineer
>
> Service Provider Division, TiVo Inc
>
> 408-519-9607
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>



-- 
Best regards, Ruslan.