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.3 -r1.6.10.4
--- openacs-4/packages/dotlrn/www/admin/departments.xql	30 Sep 2004 17:14:09 -0000	1.6.10.3
+++ openacs-4/packages/dotlrn/www/admin/departments.xql	22 Nov 2004 22:23:08 -0000	1.6.10.4
@@ -10,7 +10,7 @@
                     from dotlrn_classes
                     where department_key = dotlrn_departments_full.department_key) as n_classes
             from dotlrn_departments_full
-	     where 1 = 1
+	    $keyword_clause	
 	    [template::list::page_where_clause -and -name "departments" -key "dotlrn_departments_full.department_key"]
 	    [template::list::orderby_clause -orderby -name "departments"]
         </querytext>
@@ -24,9 +24,22 @@
                     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"]
 
         </querytext>
     </fullquery>
 
+    <partialquery name="departments_keyword">
+      <querytext>
+	  where lower(pretty_name) like '%'||lower(:keyword)||'%'
+      </querytext>
+    </partialquery>
+
+    <partialquery name="departments_without_keyword">
+      <querytext>
+	  where 1 = 1 
+      </querytext>
+    </partialquery>
+
 </queryset>