Index: openacs-4/packages/dotlrn/www/admin/departments.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/departments.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/dotlrn/www/admin/departments.xql	1 May 2002 01:19:47 -0000	1.5
+++ openacs-4/packages/dotlrn/www/admin/departments.xql	14 Aug 2002 19:18:50 -0000	1.6
@@ -5,7 +5,10 @@
     <fullquery name="select_departments">
         <querytext>
             select department_key,
-                   pretty_name
+                   pretty_name,
+                   (select count(*)
+                    from dotlrn_classes
+                    where department_key = dotlrn_departments_full.department_key) as n_classes
             from dotlrn_departments_full
             order by pretty_name,
                      department_key