Index: openacs-4/packages/dotlrn/www/admin/term.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/term.xql,v
diff -u -r1.7.10.2 -r1.7.10.3
--- openacs-4/packages/dotlrn/www/admin/term.xql 22 Nov 2004 22:23:08 -0000 1.7.10.2
+++ openacs-4/packages/dotlrn/www/admin/term.xql 4 Mar 2005 16:18:57 -0000 1.7.10.3
@@ -13,114 +13,6 @@
-
-
- select dotlrn_class_instances_full.*,
- (select count(*)
- from dotlrn_member_rels_approved
- where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id) as n_members
- from dotlrn_class_instances_full
- $keyword_clause
- and dotlrn_class_instances_full.term_id = :term_id
- [template::list::page_where_clause -and -name "classes" -key "dotlrn_class_instances_full.class_instance_id"]
- [template::list::orderby_clause -orderby -name "classes"]
-
-
-
-
-
- select dotlrn_class_instances_full.*,
- (select count(*)
- from dotlrn_member_rels_approved
- where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id) as n_members
- from dotlrn_class_instances_full
- $keyword_clause
- and dotlrn_class_instances_full.term_id = :term_id
- [template::list::orderby_clause -orderby -name "classes"]
-
-
-
-
-
- select dotlrn_class_instances_full.*,
- (select count(*)
- from dotlrn_member_rels_approved
- where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id) as n_members
- from dotlrn_class_instances_full
- $keyword_clause
- and dotlrn_class_instances_full.term_id = :term_id
- and dotlrn_class_instances_full.department_key = :department_key
- [template::list::page_where_clause -and -name "classes" -key "dotlrn_class_instances_full.class_instance_id"]
- [template::list::orderby_clause -orderby -name "classes"]
-
-
-
-
-
- select dotlrn_class_instances_full.*,
- (select count(*)
- from dotlrn_member_rels_approved
- where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id) as n_members
- from dotlrn_class_instances_full
- $keyword_clause
- and dotlrn_class_instances_full.term_id = :term_id
- and dotlrn_class_instances_full.department_key = :department_key
- [template::list::orderby_clause -orderby -name "classes"]
-
-
-
-
-
- select dotlrn_class_instances_full.*,
- (select count(*)
- from dotlrn_member_rels_approved
- where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id) as n_members
- from dotlrn_class_instances_full
- $keyword_clause
- [template::list::page_where_clause -and -name "classes" -key "dotlrn_class_instances_full.class_instance_id"]
- [template::list::orderby_clause -orderby -name "classes"]
-
-
-
-
-
- select dotlrn_class_instances_full.*,
- (select count(*)
- from dotlrn_member_rels_approved
- where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id) as n_members
- from dotlrn_class_instances_full
- $keyword_clause
- [template::list::orderby_clause -orderby -name "classes"]
-
-
-
-
-
- select dotlrn_class_instances_full.*,
- (select count(*)
- from dotlrn_member_rels_approved
- where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id) as n_members
- from dotlrn_class_instances_full
- $keyword_clause
- and dotlrn_class_instances_full.department_key = :department_key
- [template::list::page_where_clause -and -name "classes" -key "dotlrn_class_instances_full.class_instance_id"]
- [template::list::orderby_clause -orderby -name "classes"]
-
-
-
-
-
- select dotlrn_class_instances_full.*,
- (select count(*)
- from dotlrn_member_rels_approved
- where dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id) as n_members
- from dotlrn_class_instances_full
- $keyword_clause
- and dotlrn_class_instances_full.department_key = :department_key
- [template::list::orderby_clause -orderby -name "classes"]
-
-
-
where lower(dotlrn_class_instances_full.pretty_name) like '%'||lower(:keyword)||'%'