Index: openacs-4/packages/dotlrn-catalog/www/dt-admin/course-list.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/www/dt-admin/course-list.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/dotlrn-catalog/www/dt-admin/course-list.xql	16 Feb 2005 00:22:12 -0000	1.2
+++ openacs-4/packages/dotlrn-catalog/www/dt-admin/course-list.xql	16 Feb 2005 22:21:30 -0000	1.3
@@ -20,6 +20,26 @@
       </querytext>
 </fullquery>
 
+<fullquery name="get_course_info_keyword">      
+      <querytext>
+            select cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.item_id
+	    from dotlrn_catalog cc, cr_items ci
+ 	    where cc.course_id = ci.live_revision and  
+	    lower(cc.course_name) like lower('%$keyword%') and
+	    ci.item_id in (
+		select object_id from acs_permissions where grantee_id = :user_id and
+		privilege = 'admin')
+      </querytext>
+</fullquery>
+
+<fullquery name="get_course_info_site_wide_keyword">      
+      <querytext>
+            select cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.item_id
+	    from dotlrn_catalog cc, cr_items ci
+ 	    where cc.course_id = ci.live_revision and lower(cc.course_name) like lower('%$keyword%')
+      </querytext>
+</fullquery>
+
 <fullquery name="get_asm_name">
       <querytext>
             select cr.title from
@@ -34,7 +54,7 @@
       <querytext>
 	    select cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.item_id
 	    from dotlrn_catalog cc, cr_items ci
- 	    where cc.course_id = ci.live_revision and  
+ 	    where cc.course_id = ci.live_revision and 
 	    ci.item_id in (
 		select object_id from acs_permissions where grantee_id = :user_id and
 		privilege = 'admin')
@@ -49,5 +69,23 @@
       </querytext>
 </fullquery>
 
+<fullquery name="paginator_keyword">      
+      <querytext>
+	    select cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.item_id
+	    from dotlrn_catalog cc, cr_items ci
+ 	    where cc.course_id = ci.live_revision and lower(cc.course_name) like lower('%$keyword%') and 
+	    ci.item_id in (
+		select object_id from acs_permissions where grantee_id = :user_id and
+		privilege = 'admin')
+      </querytext>
+</fullquery>
 
+<fullquery name="site_wide_paginator_keyword">      
+      <querytext>
+            select cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.item_id
+	    from dotlrn_catalog cc, cr_items ci
+ 	    where cc.course_id = ci.live_revision lower(cc.course_name) like lower('%$keyword%') and
+      </querytext>
+</fullquery>
+
 </queryset>