554 - Ought to have a "show all recent activity" query.

Status: RESOLVED WONTFIX

(Bugzilla :: Bugzilla-General, enhancement)

Description

[Terry Weissman]

The query page ought to have a choice of either showing the bugs (like it does
today) or showing activity in bugs (sort of like what the "View Bug Activity"
link does now).  I think the database tables we have now will support it (well,
probably need to add an index or two to the activity table).

Comment 1

[Terry Weissman]

The database is being reorganized a bit.  Instead of the Bugzilla product,
a new Webtools product has been created, with Bugzilla being a component of it.

This bug is being moved from the old Bugzilla product to the new Webtools
product.

Comment 2

[leger]

"View Bug Activity" is in and works.  I would call this fixed.  Yes?

Comment 3

[Terry Weissman]

No, "view bug activity" shows what has happened on a single bug.  I would like
(someday) to be able to say "show me everything that has happened to any bug
in this project in the last week".  Wouldn't that be cool?

Comment 4

[leger]

Yep...that would be the cats meow....:-)

Comment 5

[Terry Weissman]

Reassigning to [e-mail], who now has front-line responsibility for
all Bonsai and Bugzilla bugs.

Comment 6

[Terry Weissman]

Reassigning back to me.  That stuff about me no longer being the front-line
person responsible for Bugzilla and Bonsai turned out to be short-lived.
Please pardon our confusion, and I'm very sorry about the spam.

Comment 7

[Hixie (not reading bugmail)]

Would the following do what you are looking for? Do a query that selects the
bugs for which you wish to know the activity, setting the "changed in the last
n days" field to some reasonable number. Then, once the buglist is up, go to
the bottom, and next to "Long Format" you would find a "Activity in Long
Format" button (or link), which gives you the result of the "View Bug Activity"
link that is present on each bug, but for all the bugs on the list?

Terry: this could be implemented by iterating show_activity.cgi over each bug
in the list.

Comment 8

[Terry Weissman]

Yeah, that would be pretty close.  It would be nice to query a time range,
rather than just "changes made in the last n days", but whatever.

Comment 9

[Terry Weissman]

[e-mail] is the new owner of Bugzilla and Bonsai.  (For details,
see my posting in netscape.public.mozilla.webtools,
news://news.mozilla.org/38F5D90D.F40E8C1A%40geocast.com .)

Comment 10

[Matthew Barnson]

This bug has been fixed.  You can select in the query page by "where the fields"
and a date range, or changed to value.  Let's resolve this ancient bug.

Comment 11

[Dave Miller [:justdave]]

Querying on what fields have changed is not the same as looking at a list of what 
has changed on a bug.  This has not been fixed yet, either.

Comment 12

[Stephan Niemz]

Adding default QA contact to all open Webtools/Bugzilla bugs lacking one.
Sorry for the spam.

Comment 13

[Zach Lipton [:zach]]

moving

Comment 14

[John Vandenberg]

Attachment: v1

Rather than futher complicate query.cgi/buglist.cgi, this patch adds a link to
the bottom of buglist.cgi, to display the activity log of those bugs listed. 
Once on show_activity the user can enter an appropriate date range. 
Comments/Ideas welcome.

Comment 15

[Andreas Franke (gone)]

> Comments/Ideas welcome.

Here is some brainstorming:

I think "show recent activity" would be most useful in combination with
bug 72132 ("[RFE] Daily/Weekly digests."), or even together with offering a
"pull" model for notifications. (Is there a bug on the latter yet?)

I have bookmarked a stored query that asks for all bugs in the Bugzilla product
where someone added a comment after some date. Every day or two, I used to load
this bookmark, change the date to the one from my last buglist, then run it.
Then I write down the date from the new buglist manually, and read through the
bugs. There are several problems:
- As soon as I do another bugzilla query, the "current buglist remembered by
bugzilla" gets overwritten, and the "Next" link on the bug I'm working on
disappears. 
- When reading the bugs on the list, I have to manually find the first comment
that is new.
Both of these could be solved or worked around by displaying the "recent
activity" for each bug on the buglist itself: The information on such a page
would be self-contained, so it wouldn't matter much if the "current buglist"
gets overwritten, and only the recent comments are displayed (together with the
non-comment-activity), so no need to search for anything.
The downside of this approach is that it doesn't scale particularly well: If the
number of bugs or the time interval is too large, then the result will be a
_huge_ page, and the browser probably won't be able to handle it (or crash with
an out-of-memory error).

Comment 16

[basic]

remove self

Comment 17

[Dave Miller [:justdave]]

Reassigning all of my "future" targetted bugs to indicate that I'm not presently
working on them, and someone else could feel free to work on them. (sorry for
the spam if you got this twice, it didn't take right the first time)

Comment 18

[Jouni Heikniemi]

Comment on attachment 72204 [details] [diff] [review]
v1

Pre-templatization stuff. Ugh.

Comment 19

[Rajesh]

(In reply to comment #0)
> The query page ought to have a choice of either showing the bugs (like it does
> today) or showing activity in bugs (sort of like what the "View Bug Activity"
> link does now).  I think the database tables we have now will support it (well,
> probably need to add an index or two to the activity table).

gjkghah

Comment 20

[Sammy]

Just for testing

Comment 21

[Frédéric Buclin]

Per comment 7 and comment 8, fixing bug 158205 would make terry happy.

Comment 22

[Gervase Markham [:gerv]]

BMO has a customization which shows recent activity for one or more users:
https://bugzilla.mozilla.org/page.cgi?id=user_activity.html

Would porting that upstream be sufficient to fix this bug? 

Alternatively, this bug has been dormant now for nearly 6 years, and no-one seems to have given a set of use cases for it. We don't have people crying out for this function - there are only 9 people on the CC list. Does that make it a WONTFIX?

Gerv

Comment 23

[:glob ✱]

(In reply to Gervase Markham [:gerv] from comment #22)
> BMO has a customization which shows recent activity for one or more users:
> https://bugzilla.mozilla.org/page.cgi?id=user_activity.html
> Would porting that upstream be sufficient to fix this bug? 

that's bug 387586

> Alternatively, this bug has been dormant now for nearly 6 years, and no-one
> seems to have given a set of use cases for it. We don't have people crying
> out for this function - there are only 9 people on the CC list. Does that
> make it a WONTFIX?

i agree, marking as WONTFIX.