Topic on Talk:Quality Assurance/Strategy

Just a note about a couple of bug triage metrics:

• A search like this shows the bugs we acted upon within a week in a certain component, but it doesn't count the reprts that were moved to another components, right? If this is true, last week we acted on 97 reports instead of 87.
• It would be great to find a query showing which users changed anything within a query. The data is there in the Change history, but Bugzilla searches/reports only will show bug reporters or assigned...

This post was posted by Qgil-WMF, but signed as Qgil.

• I cannot come up with a way to create *one* query in Bugzilla's query web interface to also cover those tickets that got moved out of the component (like "any tickets changed that were in the component X between 2013-04-01 and 2013-04-07", only an additional one "component | changed from | Skin and page rendering" (for the last bug day) which you probably also used to find out that we talk about 10 additional tickets: https://bugzilla.wikimedia.org/buglist.cgi?query_format=advanced&chfieldto=2013-04-07%2023%3A59&chfieldfrom=2013-04-01%200%3A00&o1=changedfrom&f1=component&v1=Skin%20and%20page%20rendering
• Generic "who changed something" queries are pretty bad in Bugzilla. You have "changed by" in the custom/boolean queries, but it always requires either defining a field or a role (reporter, commenter, assignee etc). Again, this may work with some SQL queries on "bugs_activity.who" (I normall take a look at http://www.bugzilla.org/docs/queries.html and https://wiki.mozilla.org/Bugzilla:SQLCookBook to get ideas for those rare moments when I want to fiddle with SQL) but there's no way in the query web interface that comes to my mind. :-(