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.6.10.2 -r1.6.10.3
--- openacs-4/packages/dotlrn/www/admin/departments.xql 2 Aug 2004 10:42:37 -0000 1.6.10.2
+++ openacs-4/packages/dotlrn/www/admin/departments.xql 30 Sep 2004 17:14:09 -0000 1.6.10.3
@@ -5,14 +5,28 @@
select department_key,
- pretty_name,
+ pretty_name as department_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
+ where 1 = 1
+ [template::list::page_where_clause -and -name "departments" -key "dotlrn_departments_full.department_key"]
+ [template::list::orderby_clause -orderby -name "departments"]
+
+
+ select department_key,
+ pretty_name as department_name,
+ (select count(*)
+ from dotlrn_classes
+ where department_key = dotlrn_departments_full.department_key) as n_classes
+ from dotlrn_departments_full
+ [template::list::orderby_clause -orderby -name "departments"]
+
+
+
+