Question

I'm looking for a way to get all cases that were due for a certain milestone on a certain date.

For example: give me all cases that were due for milestone "Release 1.1" on the 21st of April 2010! (If a case was removed from "Release 1.1" on the 22nd of April, it should still appear in the querys results because on the 21st it was still due for "Release 1.1".)

Are such queries possible? Web, XML API, Plugin-Code, SQL,... anything's welcome. :)

thanks

Answer 1

Only the current milestone for a case is set in the Bug table, meaning when it is changed, that value is changed, losing the old values.

The only way FogBugz stores historical milestone information for a case is in the BugEvent table. For example, try this SQL query to see bugevents where milestones were changed:

SELECT * FROM BugEvent WHERE sChanges LIKE '%Milestone changed%';

To determine what milestone a case had at a given time, you will need to build the history from the bug events. You might want to write a plugin which keeps the history in a form more easily accessible, with a backfill it can run to build up the initial data.

Update: This may change with new reporting features in FogBugz 8.