Is there a way for me to run a report that would list all users and then
group them by # of tickets created and show the subject of each ticket? I am
thinking a 3 column table Col1, Cell 1: user1 Col 2, cell 1: all tickets for
user1, col 3, cell 1: total# of tix and then sort it by #tix created?
Greg Evans
Hood Canal Communications
(360) 898-2481 ext.212
Greg Evans wrote:
Is there a way for me to run a report that would list all users and
then group them by # of tickets created and show the subject of each
ticket? I am thinking a 3 column table Col1, Cell 1: user1 Col 2, cell
1: all tickets for user1, col 3, cell 1: total# of tix and then sort
it by #tix created?
**Greg Evans
Hood Canal Communications
(360) 898-2481 ext.212
The easiest way to do that is probably to build your query in Perl using
the RT API.
Thanks, I will try to look into that. Looks like it may be difficult
Greg Evans
Hood Canal Communications
(360) 898-2481 ext.212From: Jason Fenner [mailto:jfenner@vitamix.com]
Sent: Monday, June 16, 2008 1:07 PM
To: Greg Evans
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Need to make a report and not sure how to do it
Greg Evans wrote:
Is there a way for me to run a report that would list all users and
then group them by # of tickets created and show the subject of each
ticket? I am thinking a 3 column table Col1, Cell 1: user1 Col 2, cell
1: all tickets for user1, col 3, cell 1: total# of tix and then sort
it by #tix created?
**Greg Evans
Hood Canal Communications
(360) 898-2481 ext.212
The easiest way to do that is probably to build your query in Perl using
the RT API.