610452 - no way to search for specific flag changes in a given time frame

Status: REOPENED

(Bugzilla :: Query/Bug List, defect)

Description

[OOO until Apr 20; Dan Mosedale (:dmosedale, :dmose)]

Even with boolean charts, it's not possible to search for "the bugs that got r? in a specific time frame".

Whether or not this can be fixed in BzAPI itself or if it needs to wait on the new boolean charts impl (assuming that would help), I don't know.

The problem is that it's possible to search for something in a given timeframe that has flag changes, but it only appears to be able to search for changed_to, and reviews are recorded in the history as strings that look like "added: review?([e-mail])".

The use case here is that I want to understand how our ability to turn around code reviews varies over time.

Comment 1

[Gervase Markham [:gerv]]

Yep, I think that the best one can do is search for reviews in a specific time frame where no-one was requested:
https://bugzilla.mozilla.org/buglist.cgi?type0-1-0=changedbefore&field0-1-0=flagtypes.name&field0-0-0=flagtypes.name&query_format=advanced&value0-2-0=2010-10-01&value0-1-0=2010-10-28&field0-2-0=flagtypes.name&type0-0-0=changedto&value0-0-0=review%3F&type0-2-0=changedafter&product=Bugzilla

You can't search for reviews where anyone was requested, because the matching on the "added" column is literal only (no regexp).

This is a limitation in Bugzilla, not in the BzAPI. Sorry :-|

Gerv

Comment 2

[OOO until Apr 20; Dan Mosedale (:dmosedale, :dmose)]

Reopening and moving to the Bugzilla product.  Max, is this something that the new boolean chart functionality is likely to help with?

Comment 3

[Max Kanat-Alexander]

(In reply to comment #2)
> Reopening and moving to the Bugzilla product.  Max, is this something that the
> new boolean chart functionality is likely to help with?

  Hmm. I'm not sure, but I think so, yeah. This would probably be the ultimate culmination of all of the Search work (that is, it would require absolutely every planned enhancement in order for this to work, and possibly then some).

Comment 4

[OOO until Apr 20; Dan Mosedale (:dmosedale, :dmose)]

Since it probably wasn't clear from the original filing, the value here comes in the form making it easier to put together an app that helps us understand how quickly we're able to provide feedback to contributors who request it.  This, in turn, will allow us to work on making contributing to our projects a more rewarding experience.

Comment 5

[Max Kanat-Alexander]

That makes total sense--when I did community research on the Bugzilla Project, the speed of response to reviews was one of the top three factors in determining the retention of community contributors.

Comment 6

[Simon Green]

This is now covered in bug 677757, probably can be marked as a duplicate (but I don't have the permission to do so)