Index: openacs-4/packages/bug-tracker/www/patch-list.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/patch-list.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/bug-tracker/www/patch-list.xql	26 Sep 2003 08:10:36 -0000	1.2
+++ openacs-4/packages/bug-tracker/www/patch-list.xql	24 Feb 2005 13:33:04 -0000	1.3
@@ -23,16 +23,16 @@
       <querytext>
 
                 select c.component_name,
-                       c.component_id,
-                       (select count(*) 
+                       c.component_id, 
+                       s.count
+                from   bt_components c,
+                       (select p.component_id, count(*) as count
                         from   bt_patches p 
-                        where  p.project_id = :package_id 
-                        and    p.component_id = c.component_id
-                       ) as count
-                from   bt_components c
-                where  exists (select 1 from bt_patches p2
-                               where p2.component_id = c.component_id)
-                order  by c.component_name
+                        where  p.project_id = :package_id
+			group by p.component_id
+                       ) s
+                where  s.component_id = c.component_id
+                order  by lower(c.component_name)
 
       </querytext>
 </fullquery>