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