Re: Duplicates

[Olav Vitters <olav bkor dhs org>]

On Fri, Sep 21, 2007 at 06:16:24PM -0500, Federico Mena Quintero wrote:
> Our bugzilla has a lovely http://bugzilla.gnome.org/duplicates.cgi to
> look for the bugs with the highest number of duplicates.  Is there
> custom code to generate this page?  If so, where can I get it? :)

Only a slight change; duplicates.cgi itself comes standard with Bugzilla
(Novell bugzilla should have it). It is in bugzilla-newer module in
svn.gnome.org. To see differences between GNOME Bugzilla and upstream,
use 'cvs diff' (the upstream CVS directories are in GNOME SVN).

> I'd like to plug the same code into Novell's bugzilla so that we can get
> better bug stats.

See attached for the patch, but it doesn't change any of the
functionality.. only adds some fields to the display.

-- 
Regards,
Olav

Index: duplicates.cgi
===================================================================
RCS file: /cvsroot/mozilla/webtools/bugzilla/duplicates.cgi,v
retrieving revision 1.44
diff -u -p -r1.44 duplicates.cgi
--- duplicates.cgi	10 Jul 2004 07:17:02 -0000	1.44
+++ duplicates.cgi	21 Sep 2007 23:04:00 -0000
@@ -221,12 +221,14 @@ if (scalar(%count)) {
 
     my $query = new Bugzilla::Search('fields' => [qw(bugs.bug_id
                                                      map_components.name
+                                                     map_products.name
                                                      bugs.bug_severity
                                                      bugs.op_sys
                                                      bugs.target_milestone
                                                      bugs.short_desc
                                                      bugs.bug_status
                                                      bugs.resolution
+                                                     bugs.gnome_target
                                                     )
                                                  ],
                                      'params' => $params,
@@ -237,19 +239,21 @@ if (scalar(%count)) {
     while (MoreSQLData()) {
         # Note: maximum row count is dealt with in the template.
 
-        my ($id, $component, $bug_severity, $op_sys, $target_milestone, 
-            $short_desc, $bug_status, $resolution) = FetchSQLData();
+        my ($id, $component, $product, $bug_severity, $op_sys, $target_milestone, 
+            $short_desc, $bug_status, $resolution, $gnome_target) = FetchSQLData();
 
         push (@bugs, { id => $id,
                        count => $count{$id},
                        delta => $delta{$id}, 
                        component => $component,
+                       product => $product,
                        bug_severity => $bug_severity,
                        op_sys => $op_sys,
                        target_milestone => $target_milestone,
                        short_desc => $short_desc,
                        bug_status => $bug_status, 
-                       resolution => $resolution });
+                       resolution => $resolution,
+                       gnome_target => $gnome_target });
         push (@bug_ids, $id); 
     }
 }