Last Comment Bug 121335 - Implement "last changed by"
: Implement "last changed by"
Status: NEW
Product: Bugzilla
Classification: Server Software
Component: Query/Bug List (show other bugs)
: 2.15
: All All
P3 enhancement (vote)
: ---
Assigned To: Nobody; OK to take it and work on it
: default-qa
: 312085 391513 (view as bug list)
Depends on:
Blocks: 418953
  Show dependency treegraph
Reported: 2002-01-22 18:03 PST by John Keiser (jkeiser)
Modified: 2008-10-13 21:26 PDT (History)
5 users (show)
See Also:
QA Whiteboard:
Iteration: ---
Points: ---


Description User image John Keiser (jkeiser) 2002-01-22 18:03:59 PST
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 User image Andreas Franke (gone) 2002-01-23 03:48:45 PST
Is an additional comment a change? Probably so. Then the last entry from the
bugs_activity table is not enough.
Comment 2 User image John Keiser (jkeiser) 2002-02-04 10:51:12 PST
Whenever our changed date gets set, the changer should be set, IMO.
Comment 3 User image Matthew Tuck [:CodeMachine] 2002-05-24 05:21:44 PDT
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 User image Bradley Baetz (:bbaetz) 2002-05-24 20:07:40 PDT
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 User image John Keiser (jkeiser) 2002-05-24 22:30:34 PDT
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.
Comment 6 User image Frédéric Buclin 2007-07-10 13:34:52 PDT
*** Bug 312085 has been marked as a duplicate of this bug. ***
Comment 7 User image Christian Volkmann 2008-02-12 00:59:07 PST
*** Bug 391513 has been marked as a duplicate of this bug. ***

Note You need to log in before you can comment on or make changes to this bug.