Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Request Tracker: Users

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

 

 

Request Tracker users RSS feed   Index | Next | Previous | View Threaded


gevans at hcc

Jun 16, 2008, 12:51 PM

Post #1 of 3 (476 views)
Permalink
Need to make a report and not sure how to do it

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


jfenner at vitamix

Jun 16, 2008, 1:07 PM

Post #2 of 3 (463 views)
Permalink
Re: Need to make a report and not sure how to do it [In reply to]

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.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales [at] bestpractical


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


gevans at hcc

Jun 16, 2008, 1:27 PM

Post #3 of 3 (464 views)
Permalink
Re: Need to make a report and not sure how to do it [In reply to]

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

Greg Evans
Hood Canal Communications
(360) 898-2481 ext.212

-----Original Message-----
From: Jason Fenner [mailto:jfenner [at] vitamix]
Sent: Monday, June 16, 2008 1:07 PM
To: Greg Evans
Cc: rt-users [at] lists
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.

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales [at] bestpractical


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Request Tracker users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.