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:[email protected]] Sent: Thursday, August 27, 2009 3:10 PM To: Kimberly McKinnis Cc: [email protected] 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<[email protected]> 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: [email protected] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Best regards, Ruslan. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
