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

[Ruslan Zakirov]

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.