add the ability to search by "assignee last login date"

VERIFIED FIXED

Status

()

bugzilla.mozilla.org
General
VERIFIED FIXED
3 years ago
3 years ago

People

(Reporter: Dave Garrett, Assigned: glob)

Tracking

Production

Details

Attachments

(1 attachment)

(Reporter)

Description

3 years ago
Bug 444222 apparently got lost track of many years ago, yet for all that time it was still assigned to an account that hasn't been active since 2012-01-13. (based on Bugzilla profile info) It should be relatively easy to find other bugs like this.

I would like to request that all currently open bugs that have an assignee that has not been active for at least one year have their assignee reset to nobody and status changed from ASSIGNED to NEW or UNCONFIRMED if never confirmed. A QA contact reset might also be warranted. All applicable email notifications should still be sent.

Additionally, I would like to request that a list of these bugs be posted here so they can be triaged and closed, reassigned, or otherwise dealt with as needed.
as different teams use bugzilla differently, making this sort of bulk change problematic and difficult to gain consensus on.  it's also a single-shot fix, and doesn't deal with this being an ongoing issue.


a better approach to this issue is to make it trivial to find any open bugs with an inactive assignee, enabling the component owners to update the bugs in bulk themselves.  morphing bug to indicate that.
Component: Administration → General
Summary: reset assignees for all open bugs where the assignee is no longer a contributor → add the ability to search by "assignee last login date"
Created attachment 8472095 [details] [diff] [review]
1052851_1.patch
Assignee: nobody → glob
Status: NEW → ASSIGNED
Attachment #8472095 - Flags: review?(dkl)
Comment on attachment 8472095 [details] [diff] [review]
1052851_1.patch

Review of attachment 8472095 [details] [diff] [review]:
-----------------------------------------------------------------

Nit (to fix on commit): I would prefer to change 'assignee_seen' to 'assignee_last_login' everywhere 
in the code as 'assignee_seen' makes me think "the last time the assignee saw the associated bug" where
in reality we are just looking at the last time a user accessed Bugzilla generally.

r=dkl
Attachment #8472095 - Flags: review?(dkl) → review+
(In reply to David Lawrence [:dkl] from comment #3)
> Comment on attachment 8472095 [details] [diff] [review]
> 1052851_1.patch
> 
> Review of attachment 8472095 [details] [diff] [review]:
> -----------------------------------------------------------------
> 
> Nit (to fix on commit): I would prefer to change 'assignee_seen' to
> 'assignee_last_login' everywhere 
> in the code as 'assignee_seen' makes me think "the last time the assignee
> saw the associated bug" where
> in reality we are just looking at the last time a user accessed Bugzilla
> generally.
> 
> r=dkl

Forgot to say:

Otherwise looks good and worked as expected. r=dkl
To ssh://gitolite3@git.mozilla.org/webtools/bmo/bugzilla.git
   cdf7ace..747f1f1  master -> master
Status: ASSIGNED → RESOLVED
Last Resolved: 3 years ago
Resolution: --- → FIXED
this is now live.

here's a query which shows "Core" bugs where the assignee hasn't logged in to bugzilla this year: http://mzl.la/1AQRLpC
(Reporter)

Comment 7

3 years ago
(In reply to Byron Jones ‹:glob› from comment #6)
> this is now live.
> 
> here's a query which shows "Core" bugs where the assignee hasn't logged in
> to bugzilla this year: http://mzl.la/1AQRLpC

It looks like it's counting the default assignees as users for the search. (e.g. bug 367833 is in that list, but its assignee is xforms@core.bugs) This search really needs to filter out those default assignees.
(In reply to Dave Garrett from comment #7)
> It looks like it's counting the default assignees as users for the search.
> (e.g. bug 367833 is in that list, but its assignee is xforms@core.bugs) This
> search really needs to filter out those default assignees.

the default assignee for the xforms component is nobody@mozilla.org, however excluding all .bugs users should help with those older bugs:

http://mzl.la/1wo3yuQ (currently returns 255 fewer bugs).
(Reporter)

Comment 9

3 years ago
(In reply to Byron Jones ‹:glob› from comment #8)
> the default assignee for the xforms component is nobody@mozilla.org, however
> excluding all .bugs users should help with those older bugs:
> 
> http://mzl.la/1wo3yuQ (currently returns 255 fewer bugs).

That's a notable improvement, thanks.

It looks like restricting the search to only assigned bugs gives a far more manageable list.

http://mzl.la/1qJPmgg (currently returns 449 bugs)

The ability to search for this is quite helpful to have, but it looks like some additional human work will be required to search through the bugs where people just dropped them because they were legitimately deprioritized and didn't mark it as such.

I think my initial suggestion of just mass changing them turns out to be not viable in light of this new information as lots of those just need to be closed out as obsolete. There's way more dropped assigned bugs in the system than I suspected.

In any case, this new feature appears to work as intended. Thanks. V. Fixed.
Status: RESOLVED → VERIFIED
You need to log in before you can comment on or make changes to this bug.