1527841 - Add ability to search for bugs where assignee or needinfo’d people have last seen gt/lt X

Status: RESOLVED FIXED

(bugzilla.mozilla.org :: Search, enhancement, P2)

Description

[Calixte Denizet (:calixte)]

On the same model as "assignee_last_login" but for needinfo.

Comment 1

[Kohei Yoshino [:kohei]]

The needinfo flag can be multiple, so it may be a bit hard to see this. Ah, it will also be a problem when Assignee becomes multiple. 🤔

Comment 2

[Calixte Denizet (:calixte)]

So maybe we could have kind of:
"all the ni"
"any of the ni"
"number of ni"
and the same for assignee.

Comment 3

[Kohei Yoshino [:kohei]]

I’ve realized that the assignee_last_login column is useless. It’s literally the last login date of the user, not the last seen date in spite of the internal field name called last_seen_date , which is perhaps a legacy of the days when people had logged into Bugzilla everyday at 9am and shut down their workstation at 5pm. Now people keep logged in, so the date can be quite old.

We need the new assignee_last_seen column based on another internal field called last_activity_ts, which is currently a part of the UserProfile extension. I’ll file a separate bug for that.

The same applies to needinfo. What we need here is not needinfo_last_login but needinfo_last_seen, right?

Comment 4

[Kohei Yoshino [:kohei]]

Attachment: GitHub Pull Request

Comment 6

[Suhaib Mujahid [:suhaib]]

https://bugzilla.mozilla.org/show_bug.cgi?id=1527841:

Kohei Yoshino - comment #3

I’ve realized that the assignee_last_login column is useless. It’s literally the last login date of the user, not the last seen date in spite of the internal field name called last_seen_date , which is perhaps a legacy of the days when people had logged into Bugzilla everyday at 9am and shut down their workstation at 5pm. Now people keep logged in, so the date can be quite old.

We need the new assignee_last_seen column based on another internal field called last_activity_ts, which is currently a part of the UserProfile extension. I’ll file a separate bug for that.

The same applies to needinfo. What we need here is not needinfo_last_login but needinfo_last_seen, right?

Comment 7

[David Lawrence [:dkl]]

Merged
https://github.com/mozilla-bteam/bmo/commit/617b0ebb46c3cefa3d3844f3e6dd7414f4dd7632