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 @@
     <fullquery name="select_departments">
         <querytext>
             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"]
         </querytext>
     </fullquery>
 
+    <fullquery name="departments_pagination">
+        <querytext>
+            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"]
+
+        </querytext>
+    </fullquery>
+
 </queryset>