Hi Andre, *, On Mon, Jul 6, 2009 at 9:27 AM, Andre Schnabel<[email protected]> wrote:> >> >> So, was wondering - is there a report in place that shows the percentage >> of re-opened Issues? > > Afaik there is no way to get such a report (as long as you don't have dircet > access to the issue database).
Yes and no. You can query for issues that were set to REOPENED in their lifetime with the boolean charts at the bottom of the query page. Query for Status → changed to →REOPENED almost 900 issues that currently have target 3.# were reopened at some point. > This report would not give the correct answer anyway, as you need the number > of issues that once had the status "VERIFIED" and got reopened afterwards. Yes, that is the real problem. I don't know of a way to achieve that with reasonable effort (you could use xml-export of the query of reopened issues and parse that xml yourself though - but xml is slooow on the site and already has been disabled in the past because of the load it did generate) - the xml contains full issue-history and all comments, so even for a small list, the generated xml is quite big (and as mentioned: generation is sloooooow) So in theory it is possible, but in practice... > I tried to query for issues that were verified since 2009-01-01 and are now > in status reopened. This gives 2 issues. verified after 2009-01-01 and set to reopened after 2009-01-01: 139 issues But whether it was verified before reopened: Cannot tell without the xml-export/looking at the individual issue's history. ciao Christian --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
