Filtering on bugs resolved today, by person
I'd like to create a filter which lets me see all the bugs resolved/closed by an individual each day.
Because cases are reassigned to the admin user upon resolution, I can't look by "Assigned To:".
Because our support cases are answered from a generic support address, I can't search by "Sent By:".
Wednesday, October 8, 2003
I do it using Access Reports against our SQL Database.
Here is a query, call WhoResolvedWhatWhen, you can group/sort by date resolved (dtResolved)
(dbo_Bug INNER JOIN dbo_BugEvent ON
dbo_Bug.ixBug = dbo_BugEvent.ixBug) INNER JOIN
dbo_Person ON dbo_BugEvent.ixPerson =
) INNER JOIN dbo_FixFor ON dbo_Bug.ixFixFor =
(dbo_Bug.dtResolved) Is Not Null)
ORDER BY dbo_FixFor.sFixFor, dbo_Bug.dtResolved;
Monday, October 20, 2003
Fog Creek Home