With FogBugz 8, I want to get a list of cases that were at a particular status at a particular date and time via the XML API. So I might, for example, want a list of all cases that were active at midnight on the 18th of June, 2007. Ideally I want to achieve this with a search command so an arbitrary date and time can be used as required.
The data I want is more or less the list of bugs that make up the changes over time table broken down by status for a particular day. I played with retrieving a changes over time table with the XML API from a saved filtered but it doesn't appear to work (and actually wouldn't do what I want even if it did as the particular date and time being used will potentially be different every day).
I'd prefer not to query the database directly. Is there a mechanism to do this via the XML API in FogBugz 8?
