9789 - Would be nice if Bugzilla could return just the # of open bugs for an engineer.

Status: VERIFIED DUPLICATE of bug 77764

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

Description

[ekrock's old account (dead)]

What I basically want is a query result with all of the columns, including the
bug number, turned off, so all you get is the "__ bugs found." line which
normally appears at the bottom of the list.  (If you do "Choose Columns" and
uncheck all of the boxes, you still get a list of the bug numbers back.)

You'll see at the URL that I'm creating a BugAThon tracking page which has
multiple IFRAMEs, each pointing to a different query for a different engineer.
What I'd like is to only display the "__ bugs found." line in each IFRAME.

Not a high priority.  Just an idea to put on this list.

BTW, Bugzilla rocks--thank you!

Comment 1

[Matthew Tuck [:CodeMachine]]

This would be possible with bug #12282, general summary reports.

Comment 2

[Terry Weissman]

*** Bug 23499 has been marked as a duplicate of this bug. ***

Comment 3

[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 4

[Tara Hernandez]

and also 12282

Comment 5

[Stephan Niemz]

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

Comment 6

[Dave Miller [:justdave]]

Taking all of cyeh's Bugzilla bugs.

Comment 7

[Matthew Tuck [:CodeMachine]]

Moving to new Bugzilla product ...

Comment 8

[Andreas Franke (gone)]

Attachment: bugcount.cgi, derived from buglist.cgi rev. 1.139

Comment 9

[Andreas Franke (gone)]

Myk, I think this is one of the things that should be done sooner rather than
later.

I have attached a bugcount.cgi script that takes the same parameters as
buglist.cgi, but returns nothing but the total bug count.

You can see it in action on http://bugzilla.mathweb.org/

I know that the code duplication with buglist.cgi should be avoided, but I think
it's more important to have something working short-term for planning for
Mozilla 1.0. This approach is not the prettiest solution, but it works and it's
very flexible.

Other bugs about bug counts:

* Bug 77764: "Allowing to do bug counts from the query page"
[has patch since 04/26/01]

* Bug 92676: "Need summary table of bug counts"
[has patch since 08/05/01]

Currently, there is no way to do bug counting for arbitrary queries, except by
grep'ing for the "... bugs found" line in the buglist.cgi output. Please change
this. Please change this soon.

Comment 10

[Dave Miller [:justdave]]

I think your patch is a better fit on bug 77764.

Comment 11

[Andreas Franke (gone)]

No, I think this is the correct place for my patch: Bug 77764 is about
bugzilla-generated result pages, but this bug is about custom html pages with
embedded bug counts (via IFRAMEs).

Comment 12

[Andreas Franke (gone)]

Comment on attachment 48541 [details]
bugcount.cgi, derived from buglist.cgi rev. 1.139

Note: the perl path in the first line needs to be changed to
#!/usr/bonsaitools/bin/perl -w

Comment 13

[Andreas Franke (gone)]

Have a look at this page (probably the URL is only temporarily available):
http://www.ags.uni-sb.de/~afranke/mozilla/bugcounts.html
[to be viewed in Mozilla, the old 4.x doesn't support IFRAMEs]

I think this is what ekrock had in mind when he reported this bug. You can click
on the numbers to get the buglist.

But still, this is not a good long-term solution because it puts a heavy load on
bugzilla.

Comment 14

[Andreas Franke (gone)]

Attachment: bugcount.cgi that works, parses buglist output

Comment 15

[Andreas Franke (gone)]

Attachment: count script used by the bugcount.cgi above

Comment 16

[Gervase Markham [:gerv]]

This is not bug 12282.

Afranke: what this bug really means, IMO, is a checkbox on the Query page that
says: "count only". This basically means turning SELECT into SELECT COUNT in the
SQL, and means you can do big queries without waiting for ages and tying up the
db. This should be a two-line change to add the checkbox, and another two lines
to check for the value and modify the SQL.

Gerv

Comment 17

[Gervase Markham [:gerv]]

This is really a dupe of 77764. If we fix that, Andreas' scripts (which, to be
fair, are a bit hacky, and don't have the benefit of reducing Bugzilla load that
77764 might) won't be necessary.

Gerv

*** This bug has been marked as a duplicate of 77764 ***

Comment 18

[Andreas Franke (gone)]

I filed bug 104025 'Need a "results-only" mode to embed buglist via an IFRAME'
for the things that aren't covered by bug 77764.

Comment 19

[Dave Miller [:justdave]]

clearing milestone for invalid/wontfix/worksforme/duplicate so they'll show up
as untriaged if they get reopened.

Comment 20

[Matt Perry]

Verified duplicate