121335 - Implement "last changed by"

Status: NEW

(Bugzilla :: Query/Bug List, enhancement, P3)

Description

[John Keiser (jkeiser)]

I am trying to create a query that acts as much as possible like an "inbox,"
showing me only my bugs that I haven't yet looked at.  As a grand step towards
doing this would be to be able to query on "last changed by," or specifically in
my case, "not last changed by" myself.

I would expect that this would be in that boolean chart at the bottom, but a
textfield or even a checkbox saying "where I was not the last person to change
this bug" would work.  Though to be general probably the checkbox is not the
best idea.

Comment 1

[Andreas Franke (gone)]

Is an additional comment a change? Probably so. Then the last entry from the
bugs_activity table is not enough.

Comment 2

[John Keiser (jkeiser)]

Whenever our changed date gets set, the changer should be set, IMO.

Comment 3

[Matthew Tuck [:CodeMachine]]

Brad is there any easy way to do a join like this in one SQL statement?  That is
to say, join with only the record with the greatest value in a specific field
included?  Kind of like LIMIT and SORT BY combined but for a subsidiary table?

And to play devil's advocate here, and convince myself, what if two people make
changes at exactly the same time?

Comment 4

[Bradley Baetz (:bbaetz)]

Hmm. So you want to find the last time on teh activity table where the changer
was not you, and where you are ccd to the bug? I'm not sure you can do that
without subselects (or even with, at least easily)

Comment 5

[John Keiser (jkeiser)]

I doubt it is possible as well.  Comments changes, for example, do not show up
in the Bug Activity log, AFAICT.  One would really need a new field for this.