Feature Request: Global Reports - General development

BugNET Forums

Forum Development General develop... Feature Request: Global Reports

2/2/2007 8:46 AM

	elgransan
1 posts

Re: Feature Request: Global Reports

Hello, I did a simple SQL Query to obtain a global report, while we are waiting for new releases :)

select p.Name, b.Summary, b.ReportedDate, t.Name 'Type', o.Name 'Priority', s.Name 'Status', r.Name 'Resolution', b.LastUpdate, u1.userName 'Reporter', u2.userName 'AsignedTo'
from Bug b
inner join Type t on t.TypeId = b.TypeId
inner join Resolution r on r.ResolutionId = b.ResolutionId
inner join Priority o on o.PriorityId = b.PriorityId
inner join Status s on s.StatusId = b.StatusId
inner join Project p on b.ProjectId = p.ProjectId
inner join aspnet_Users u1 on u1.UserId = b.ReporterUserId
inner join aspnet_Users u2 on u2.UserId = b.AssignedToUserId
order by ReportedDate

With this query you can add filters (WHERE) with interval date, Type, Status or change the order for instance by Project, Type and then Date

The only limitation is that you cant see in this report, the efective time working on the subject.

Regards,
Santiago from Argentina!

pd. Davin the project is Great!

Page 2 of 2

Forum

Development

General develop...

Feature Request: Global Reports

Forum Policy

These Discussion Forums are dedicated to the discussion of the BugNET issue tracker.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising.
2. No Flaming or Trolling.
3. No Profanity, Racism, or Prejudice.
4. Site Moderators have the final word on approving/removing a thread or post or comment.
5. English language posting only, please.