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 -r1.7
--- openacs-4/packages/dotlrn/www/admin/departments.xql 14 Aug 2002 19:18:50 -0000 1.6
+++ openacs-4/packages/dotlrn/www/admin/departments.xql 13 Jan 2005 13:57:21 -0000 1.7
@@ -5,14 +5,41 @@
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
+ $keyword_clause
+ [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
+ $keyword_clause
+ [template::list::orderby_clause -orderby -name "departments"]
+
+
+
+
+
+
+ where lower(pretty_name) like '%'||lower(:keyword)||'%'
+
+
+
+
+
+ where 1 = 1
+
+
+