Fog Creek Software
Discussion Board




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:".

Any suggestions?

Steve Kalkwarf
Wednesday, October 08, 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)

SELECT dbo_Bug.ixBug,
            dbo_Bug.sTitle,
            dbo_FixFor.sFixFor,
            dbo_Bug.dtResolved,
            dbo_Person.sFullName,
            dbo_Bug.dtResolved,
            dbo_BugEvent.ixBugEvent
FROM  (
            (dbo_Bug INNER JOIN dbo_BugEvent ON
            dbo_Bug.ixBug = dbo_BugEvent.ixBug) INNER JOIN 
              dbo_Person ON dbo_BugEvent.ixPerson =
                dbo_Person.ixPerson
          ) INNER JOIN dbo_FixFor ON dbo_Bug.ixFixFor =
              dbo_FixFor.ixFixFor
WHERE (
              ((dbo_Bug.dtResolved)=[dbo_BugEvent].[dt] And
                (dbo_Bug.dtResolved) Is Not Null)
            AND
              ((dbo_Bug.ixStatus)>1)
            )
ORDER BY dbo_FixFor.sFixFor, dbo_Bug.dtResolved;

Daniel Goodman
Monday, October 20, 2003

*  Recent Topics

*  Fog Creek Home