Fetch historical data from sql query from Mantis DB

[turbokat]

Hi All,

I want to fetch "How many bugs were in resolved state and assigned to a particular user till last week?" The table "mantis_bug_history_table" can give this information however, it is not straight forward. It has the entries only when some field is changed.

Lets take an example -

A bug ID 2345 is opened on date 20 Oct 2010
It is resolved on 27 Oct 2010
It is assigned to John on 28 Oct Oct 2010.
It is assigned to Mike on 02nd Dec 2010
Mike has verified and closed this issue. i.e. its current status is closed.

Today is Friday 3rd Dec 2010 .. And I want to see how many issues were assigned to John in last week i.e. between Sunday 21st Nov 2010 to Saturday 27 Nov 2010?

It should display that bug ID 2345 was in resolved state and it was assigned to John between 21st Nov and 27th Nov 2010