Hi all,

 

We are quite new to trac, but what I would like to have is statistics
and overview of the tickets we do have. 

I know I can do it with sql etc., but I'm quite sure some one of you did
already.

Is there anyone who does have available the sql query to create a matrix
an overview of components and related to that the 'recordcount' of open
(bugs/enhancements, other ticket types, etc.etc.)?

 

Something Like this

                                    Bug      Enhancement    Task

Component A                15         4                      2

Component B                10         14                     4

 

 

And do you have maybe other nice to have reports - you would like to
share to us all - which are giving me overview in
tickets/time/components/etc?

 

Thanx in advance,


Roel Nicolai

E  [EMAIL PROTECTED]
 

 


***********************************************************************
The information in this message is confidential and may be legally
privileged. It is intended solely for the addressee. Access to this 
message by anyone else is unauthorized. If you are not the 
intended recipient, any disclosure, copying, or distribution of the 
message, or any action or omission taken by you in reliance on 
it is prohibited and may be unlawful. Please immediately contact 
the sender if you have received this message in error. This email 
does not constitute any commitment from Cordys Holding BV or 
any of its subsidiaries except when expressly agreed in a written 
agreement between the intended recipient and 
Cordys Holding BV or its subsidiaries.
***********************************************************************



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac 
Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to