Hello Christian, et al,
Well, this was more interesting then I thought it would be.
For whatever it's worth, I couldn't resist fiddling just one more time.
(separate queries exported to CSV and imported to Base)
Issues that held status 'closed' during 2009 = 4047
Issues that held status 'verified' during 2009 = 1502
Issues that held status 'reopened' during 2009 = 360
Of these
846 had a status of both verified and closed
136 had a status of both closed and reopened
130 had a status of both verified and reopened
75 had all three status designations during this year
So my first SWAG* at a recidivism rate is: between 1.8% and
8.9%...mmmm...maybe not too accurate
One more query
Issues that held status 'new' during 2009 = 1533
and one more join
Issues with all 4 status this year. 35 (w/current status of: 31 closed,
2 verified, 1 new, 1 reopened )
and my final SWAG - 2.3% (35/1533),
Drew
* SWAG (Silly Wild Ass[umptions] Guess)
--- the query strings used ---
verified
http://qa.openoffice.org/issues/buglist.cgi?issue_type=DEFECT&issue_type=ENHANCEMENT&issue_type=FEATURE&issue_type=PATCH&email1=&emailtype1=exact&emailassigned_to1=1&email2=&emailtype2=exact&emailreporter2=1&issueidtype=include&issue_id=&changedin=&votes=&chfield=issue_status&chfieldfrom=2009-01-01&chfieldto=2009-07-01&chfieldvalue=VERIFIED&short_desc=&short_desc_type=allwords&long_desc=&long_desc_type=allwords&issue_file_loc=&issue_file_loc_type=fulltext&status_whiteboard=&status_whiteboard_type=fulltext&keywords=&keywords_type=anytokens&field0-0-0=noop&type0-0-0=noop&value0-0-0=&field0-0-1=noop&type0-0-1=noop&value0-0-1=&field0-1-0=noop&type0-1-0=noop&value0-1-0=&cmdtype=doit&namedcmd=Base+RFE&newqueryname=&order=Reuse+same+sort+as+last+time&Submit+query=Submit+query
closed
http://qa.openoffice.org/issues/buglist.cgi?issue_type=DEFECT&issue_type=ENHANCEMENT&issue_type=FEATURE&issue_type=PATCH&email1=&emailtype1=exact&emailassigned_to1=1&email2=&emailtype2=exact&emailreporter2=1&issueidtype=include&issue_id=&changedin=&votes=&chfield=issue_status&chfieldfrom=2009-01-01&chfieldto=2009-07-01&chfieldvalue=CLOSED&short_desc=&short_desc_type=allwords&long_desc=&long_desc_type=allwords&issue_file_loc=&issue_file_loc_type=fulltext&status_whiteboard=&status_whiteboard_type=fulltext&keywords=&keywords_type=anytokens&field0-0-0=noop&type0-0-0=noop&value0-0-0=&field0-0-1=noop&type0-0-1=noop&value0-0-1=&field0-1-0=noop&type0-1-0=noop&value0-1-0=&cmdtype=doit&namedcmd=Base+RFE&newqueryname=&order=Reuse+same+sort+as+last+time&Submit+query=Submit+query
reopened
http://qa.openoffice.org/issues/buglist.cgi?issue_type=DEFECT&issue_type=ENHANCEMENT&issue_type=FEATURE&issue_type=PATCH&email1=&emailtype1=exact&emailassigned_to1=1&email2=&emailtype2=exact&emailreporter2=1&issueidtype=include&issue_id=&changedin=&votes=&chfield=issue_status&chfieldfrom=2009-01-01&chfieldto=2009-07-01&chfieldvalue=REOPENED&short_desc=&short_desc_type=allwords&long_desc=&long_desc_type=allwords&issue_file_loc=&issue_file_loc_type=fulltext&status_whiteboard=&status_whiteboard_type=fulltext&keywords=&keywords_type=anytokens&field0-0-0=noop&type0-0-0=noop&value0-0-0=&field0-0-1=noop&type0-0-1=noop&value0-0-1=&field0-1-0=noop&type0-1-0=noop&value0-1-0=&cmdtype=doit&namedcmd=Base+RFE&newqueryname=&order=Reuse+same+sort+as+last+time&Submit+query=Submit+query
new
http://qa.openoffice.org/issues/buglist.cgi?issue_type=DEFECT&issue_type=ENHANCEMENT&issue_type=FEATURE&issue_type=PATCH&email1=&emailtype1=exact&emailassigned_to1=1&email2=&emailtype2=exact&emailreporter2=1&issueidtype=include&issue_id=&changedin=&votes=&chfield=issue_status&chfieldfrom=2009-01-01&chfieldto=2009-07-01&chfieldvalue=NEW&short_desc=&short_desc_type=allwords&long_desc=&long_desc_type=allwords&issue_file_loc=&issue_file_loc_type=fulltext&status_whiteboard=&status_whiteboard_type=fulltext&keywords=&keywords_type=anytokens&field0-0-0=noop&type0-0-0=noop&value0-0-0=&field0-0-1=noop&type0-0-1=noop&value0-0-1=&field0-1-0=noop&type0-1-0=noop&value0-1-0=&cmdtype=doit&namedcmd=Base+RFE&newqueryname=&order=Reuse+same+sort+as+last+time&Submit+query=Submit+query
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
