Implement "last changed by"

NEW
Unassigned

Status

()

Bugzilla
Query/Bug List
P3
enhancement
16 years ago
9 years ago

People

(Reporter: John Keiser (jkeiser), Unassigned)

Tracking

Details

(Reporter)

Description

16 years ago
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

16 years ago
Is an additional comment a change? Probably so. Then the last entry from the
bugs_activity table is not enough.
(Reporter)

Comment 2

15 years ago
Whenever our changed date gets set, the changer should be set, IMO.
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?
Priority: -- → P3
Target Milestone: --- → Future
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)
(Reporter)

Comment 5

15 years ago
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.

Updated

14 years ago
OS: Linux → All
Hardware: PC → All
Summary: RFE: last changed by → Implement "last changed by"
Assignee: endico → nobody

Updated

11 years ago
QA Contact: mattyt-bugzilla → default-qa
Target Milestone: Future → ---

Updated

10 years ago
Duplicate of this bug: 312085

Updated

9 years ago
Duplicate of this bug: 391513

Updated

9 years ago
Blocks: 418953
Assignee: nobody → query-and-buglist
You need to log in before you can comment on or make changes to this bug.