Need to make a report and not sure how to do it


#1

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


#2

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.


#3

Thanks, I will try to look into that. Looks like it may be difficult :slight_smile:

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.