Index: openacs-4/packages/dotlrn/dotlrn.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/dotlrn.info,v diff -u -r1.118.2.3.4.8 -r1.118.2.3.4.9 --- openacs-4/packages/dotlrn/dotlrn.info 13 Oct 2004 15:12:14 -0000 1.118.2.3.4.8 +++ openacs-4/packages/dotlrn/dotlrn.info 22 Nov 2004 22:23:07 -0000 1.118.2.3.4.9 @@ -15,8 +15,8 @@ Course Management - + @@ -28,20 +28,20 @@ + + - - + + - - @@ -58,6 +58,8 @@ + + Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/dotlrn/lib/toolbar.adp'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/dotlrn/lib/toolbar.tcl'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/dotlrn/tcl/toolbar-procs.tcl'. Fisheye: No comparison available. Pass `N' to diff? Index: openacs-4/packages/dotlrn/www/admin/class.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/class.adp,v diff -u -r1.30.6.1 -r1.30.6.2 --- openacs-4/packages/dotlrn/www/admin/class.adp 29 Oct 2004 02:50:47 -0000 1.30.6.1 +++ openacs-4/packages/dotlrn/www/admin/class.adp 22 Nov 2004 22:23:08 -0000 1.30.6.2 @@ -1,96 +1,103 @@ <% - # - # Copyright (C) 2001, 2002 MIT - # - # This file is part of dotLRN. - # - # dotLRN is free software; you can redistribute it and/or modify it under the - # terms of the GNU General Public License as published by the Free Software - # Foundation; either version 2 of the License, or (at your option) any later - # version. - # - # dotLRN is distributed in the hope that it will be useful, but WITHOUT ANY - # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS - # FOR A PARTICULAR PURPOSE. See the GNU General Public License for more - # details. - # + # + # Copyright (C) 2001, 2002 MIT + # + # This file is part of dotLRN. + # + # dotLRN is free software; you can redistribute it and/or modify it under the + # terms of the GNU General Public License as published by the Free Software + # Foundation; either version 2 of the License, or (at your option) any later + # version. + # + # dotLRN is distributed in the hope that it will be useful, but WITHOUT ANY + # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS + # FOR A PARTICULAR PURPOSE. See the GNU General Public License for more + # details. + # -%> + %> - -@pretty_name@ -@context_bar@ + + @pretty_name@ + @context_bar@ - -
+
- - - - - -
- - [ - #dotlrn.new_class_instance# - ] - -
+ + + + + +
+ + [ + #dotlrn.new_class_instance# + ] + +
-
- - - - +
+ + + + - - - - -
- - #dotlrn.term#:  - -
+ + + + +
+ + #dotlrn.term#:  + +
-
+
- +
+ Search classes with : + + + + +
- + + - - - - - - -
- #dotlrn.no_class_instances# -
- + + + + + + +
+ #dotlrn.no_class_instances# +
+ -
+
Index: openacs-4/packages/dotlrn/www/admin/class.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/class.tcl,v diff -u -r1.17.6.2 -r1.17.6.3 --- openacs-4/packages/dotlrn/www/admin/class.tcl 29 Oct 2004 02:50:47 -0000 1.17.6.2 +++ openacs-4/packages/dotlrn/www/admin/class.tcl 22 Nov 2004 22:23:08 -0000 1.17.6.3 @@ -25,6 +25,7 @@ class_key:notnull {term_id -1} {orderby "term_name,asc"} + {keyword ""} } -properties { pretty_name:onevalue description:onevalue @@ -73,6 +74,12 @@ set page_query select_all_class_instances_paginator } +if { ![empty_string_p $keyword] } { + set keyword_clause [db_map class_instances_keyword] +} else { + set keyword_clause "" +} + set can_instantiate [dotlrn_class::can_instantiate] set context_bar [list [list classes [parameter::get -localize -parameter classes_pretty_plural]] $pretty_name] @@ -86,7 +93,7 @@ template::list::create \ -name class_instances \ -multirow class_instances \ - -filters { term_id {} class_key {} } \ + -filters { term_id {} class_key {} keyword {} } \ -key class_key \ -page_size 50 \ -page_flush_p t \ @@ -99,10 +106,10 @@ orderby_desc {term_name desc} link_url_eval {[export_vars -base "term" { term_id }]} } - class_name { + pretty_name { label "[_ dotlrn.class_name_header]" - orderby_asc {class_name asc} - orderby_desc {class_name desc} + orderby_asc {pretty_name asc} + orderby_desc {pretty_name desc} link_url_col url } n_members { Index: openacs-4/packages/dotlrn/www/admin/classes-chunk.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/classes-chunk.adp,v diff -u -r1.18.6.3 -r1.18.6.4 --- openacs-4/packages/dotlrn/www/admin/classes-chunk.adp 13 Oct 2004 17:32:59 -0000 1.18.6.3 +++ openacs-4/packages/dotlrn/www/admin/classes-chunk.adp 22 Nov 2004 22:23:08 -0000 1.18.6.4 @@ -1,52 +1,60 @@ <% - # - # Copyright (C) 2001, 2002 MIT - # - # This file is part of dotLRN. - # - # dotLRN is free software; you can redistribute it and/or modify it under the - # terms of the GNU General Public License as published by the Free Software - # Foundation; either version 2 of the License, or (at your option) any later - # version. - # - # dotLRN is distributed in the hope that it will be useful, but WITHOUT ANY - # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS - # FOR A PARTICULAR PURPOSE. See the GNU General Public License for more - # details. - # + # + # Copyright (C) 2001, 2002 MIT + # + # This file is part of dotLRN. + # + # dotLRN is free software; you can redistribute it and/or modify it under the + # terms of the GNU General Public License as published by the Free Software + # Foundation; either version 2 of the License, or (at your option) any later + # version. + # + # dotLRN is distributed in the hope that it will be useful, but WITHOUT ANY + # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS + # FOR A PARTICULAR PURPOSE. See the GNU General Public License for more + # details. + # -%> + %> -
+
+ + + + +
+ + <%= [parameter::get -localize -parameter departments_pretty_name] %>:  + +
+
- - - - -
- - <%= [parameter::get -localize -parameter departments_pretty_name] %>:  - -
+
+
+ Search subjects with : + + + + +
+
+ + -
+
- - - - -
-

#dotlrn.new_class_1#

-
- - - - -
- #dotlrn.no_classes# -
- + + + + + + + +
+ #dotlrn.no_classes# +
+ -
-
+
+
Index: openacs-4/packages/dotlrn/www/admin/classes-chunk.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/classes-chunk.tcl,v diff -u -r1.9.6.1 -r1.9.6.2 --- openacs-4/packages/dotlrn/www/admin/classes-chunk.tcl 30 Sep 2004 17:14:09 -0000 1.9.6.1 +++ openacs-4/packages/dotlrn/www/admin/classes-chunk.tcl 22 Nov 2004 22:23:08 -0000 1.9.6.2 @@ -26,6 +26,7 @@ classes:multirow } + if {![exists_and_not_null department_key]} { set department_key "" } @@ -64,6 +65,11 @@ set page_query select_classes_by_department_paginator } +if { [exists_and_not_null keyword] } { + set keyword_clause [db_map classes_keyword] +} else { + set keyword_clause "" +} set can_create [dotlrn_class::can_create] set can_instantiate [dotlrn_class::can_instantiate] @@ -84,7 +90,7 @@ -multirow classes \ -actions $actions \ -pass_properties { can_instantiate {} } \ - -filters { department_key {} } \ + -filters { department_key {} keyword {} } \ -key class_key \ -page_size 50 \ -page_flush_p t \ @@ -96,10 +102,10 @@ orderby_desc {department_name desc} link_url_eval {[export_vars -base "department" { department_key }]} } - class_name { + pretty_name { label "[_ dotlrn.class_name]" - orderby_asc {class_name asc} - orderby_desc {class_name desc} + orderby_asc {pretty_name asc} + orderby_desc {pretty_name desc} link_url_eval {[export_vars -base "class" { class_key }]} } n_instances { Index: openacs-4/packages/dotlrn/www/admin/classes-chunk.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/classes-chunk.xql,v diff -u -r1.7.6.2 -r1.7.6.3 --- openacs-4/packages/dotlrn/www/admin/classes-chunk.xql 30 Sep 2004 17:14:09 -0000 1.7.6.2 +++ openacs-4/packages/dotlrn/www/admin/classes-chunk.xql 22 Nov 2004 22:23:08 -0000 1.7.6.3 @@ -5,7 +5,6 @@ select dotlrn_classes_full.class_key, - dotlrn_classes_full.pretty_name as class_name, dotlrn_classes_full.pretty_name, dotlrn_classes_full.description, dotlrn_classes_full.department_key, @@ -18,6 +17,7 @@ from dotlrn_classes_full, dotlrn_departments_full where dotlrn_classes_full.department_key = dotlrn_departments_full.department_key + $keyword_clause [template::list::page_where_clause -and -name "classes" -key "dotlrn_classes_full.class_key"] [template::list::orderby_clause -orderby -name "classes"] @@ -27,7 +27,6 @@ select dotlrn_classes_full.class_key, - dotlrn_classes_full.pretty_name as class_name, dotlrn_classes_full.pretty_name, dotlrn_classes_full.description, dotlrn_classes_full.department_key, @@ -40,6 +39,7 @@ from dotlrn_classes_full, dotlrn_departments_full where dotlrn_classes_full.department_key = dotlrn_departments_full.department_key + $keyword_clause [template::list::orderby_clause -orderby -name "classes"] @@ -48,7 +48,6 @@ select dotlrn_classes_full.class_key, - dotlrn_classes_full.pretty_name as class_name, dotlrn_classes_full.pretty_name, dotlrn_classes_full.description, dotlrn_classes_full.department_key, @@ -61,6 +60,7 @@ from dotlrn_classes_full, dotlrn_departments_full where dotlrn_classes_full.department_key = :department_key + $keyword_clause and dotlrn_classes_full.department_key = dotlrn_departments_full.department_key [template::list::page_where_clause -and -name "classes" -key "dotlrn_classes_full.class_key"] [template::list::orderby_clause -orderby -name "classes"] @@ -71,7 +71,6 @@ select dotlrn_classes_full.class_key, - dotlrn_classes_full.pretty_name as class_name, dotlrn_classes_full.pretty_name, dotlrn_classes_full.description, dotlrn_classes_full.department_key, @@ -84,10 +83,18 @@ from dotlrn_classes_full, dotlrn_departments_full where dotlrn_classes_full.department_key = :department_key + $keyword_clause and dotlrn_classes_full.department_key = dotlrn_departments_full.department_key [template::list::orderby_clause -orderby -name "classes"] + + + + and lower(dotlrn_classes_full.pretty_name) like '%'||lower(:keyword)||'%' + + + Index: openacs-4/packages/dotlrn/www/admin/classes.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/classes.adp,v diff -u -r1.13.6.2 -r1.13.6.3 --- openacs-4/packages/dotlrn/www/admin/classes.adp 20 Oct 2004 10:35:23 -0000 1.13.6.2 +++ openacs-4/packages/dotlrn/www/admin/classes.adp 22 Nov 2004 22:23:08 -0000 1.13.6.3 @@ -18,11 +18,11 @@ %> - -@title@ -@context_bar@ + + @title@ + @context_bar@ + + - - Index: openacs-4/packages/dotlrn/www/admin/classes.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/classes.tcl,v diff -u -r1.14.6.3 -r1.14.6.4 --- openacs-4/packages/dotlrn/www/admin/classes.tcl 21 Oct 2004 21:08:24 -0000 1.14.6.3 +++ openacs-4/packages/dotlrn/www/admin/classes.tcl 22 Nov 2004 22:23:08 -0000 1.14.6.4 @@ -22,8 +22,9 @@ @creation-date 2001-11-04 @version $Id$ } -query { - department_key:optional + {department_key ""} {orderby "department_name,asc"} + {keyword ""} {page ""} } -properties { title:onevalue Index: openacs-4/packages/dotlrn/www/admin/departments.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/departments.adp,v diff -u -r1.19.6.5 -r1.19.6.6 --- openacs-4/packages/dotlrn/www/admin/departments.adp 13 Oct 2004 17:32:59 -0000 1.19.6.5 +++ openacs-4/packages/dotlrn/www/admin/departments.adp 22 Nov 2004 22:23:08 -0000 1.19.6.6 @@ -18,30 +18,37 @@ %> - -@title@ -@context_bar@ - -
- - - + + @title@ + @context_bar@ +
+
+ Search departments with : + + +
+
+ +
+ +
-
-

#dotlrn.new_department#

-
- - - - -
- #dotlrn.no_departments# -
+ +

#dotlrn.new_department#

+
+ + + + +
+ #dotlrn.no_departments# +
+
+ +
-
-
+ - Index: openacs-4/packages/dotlrn/www/admin/departments.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/departments.tcl,v diff -u -r1.9.6.2 -r1.9.6.3 --- openacs-4/packages/dotlrn/www/admin/departments.tcl 30 Sep 2004 17:14:09 -0000 1.9.6.2 +++ openacs-4/packages/dotlrn/www/admin/departments.tcl 22 Nov 2004 22:23:08 -0000 1.9.6.3 @@ -21,6 +21,7 @@ @creation-date 2002-01-20 @version $Id$ } -query { + {keyword ""} {orderby "department_name,asc"} page:optional } -properties { @@ -42,7 +43,14 @@ set actions [list "[_ dotlrn.new_department]" "[export_vars -base "department-new" -url { referer }]"] +if { ![empty_string_p $keyword] } { + set keyword_clause [db_map departments_keyword] +} { + set keyword_clause [db_map departments_without_keyword] +} + template::list::create \ + -filters { keyword {} } \ -name departments \ -multirow departments \ -actions $actions \ @@ -75,6 +83,7 @@ } + db_multirow departments select_departments {} ad_return_template 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"] @@ -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"] + + + where lower(pretty_name) like '%'||lower(:keyword)||'%' + + + + + + where 1 = 1 + + + Index: openacs-4/packages/dotlrn/www/admin/term.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/term.adp,v diff -u -r1.22.6.3 -r1.22.6.4 --- openacs-4/packages/dotlrn/www/admin/term.adp 30 Sep 2004 17:14:09 -0000 1.22.6.3 +++ openacs-4/packages/dotlrn/www/admin/term.adp 22 Nov 2004 22:23:08 -0000 1.22.6.4 @@ -1,93 +1,105 @@ <% - # - # Copyright (C) 2001, 2002 MIT - # - # This file is part of dotLRN. - # - # dotLRN is free software; you can redistribute it and/or modify it under the - # terms of the GNU General Public License as published by the Free Software - # Foundation; either version 2 of the License, or (at your option) any later - # version. - # - # dotLRN is distributed in the hope that it will be useful, but WITHOUT ANY - # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS - # FOR A PARTICULAR PURPOSE. See the GNU General Public License for more - # details. - # + # + # Copyright (C) 2001, 2002 MIT + # + # This file is part of dotLRN. + # + # dotLRN is free software; you can redistribute it and/or modify it under the + # terms of the GNU General Public License as published by the Free Software + # Foundation; either version 2 of the License, or (at your option) any later + # version. + # + # dotLRN is distributed in the hope that it will be useful, but WITHOUT ANY + # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS + # FOR A PARTICULAR PURPOSE. See the GNU General Public License for more + # details. + # -%> + %> - -@title@ -@context_bar@ + + @title@ + @context_bar@ - -
    + +
      -
    • - #dotlrn.Name# - @term_name@ -
      • +
    • + #dotlrn.Name# + @term_name@ +
      • -
    • - #dotlrn.Year# - @term_year@ -
      • +
    • + #dotlrn.Year# + @term_year@ +
      • -
    • - #dotlrn.Start_date# - @start_date@ -
      • +
    • + #dotlrn.Start_date# + @start_date@ +
      • -
    • - #dotlrn.End_date# - @end_date@ -
      • +
    • + #dotlrn.End_date# + @end_date@ +
      • -
      +
      -
    • - #dotlrn.Edit# #dotlrn.term_properties# -
      • +
    • + #dotlrn.Edit# #dotlrn.term_properties# +
      • -
    +
-
- +
+ -
+
- - - - - -
- - <%= [parameter::get -localize -parameter departments_pretty_name] %>:  - - - - #dotlrn.term#:  - -
+ + + + + +
+ + <%= [parameter::get -localize -parameter departments_pretty_name] %>:  + + + + #dotlrn.term#:  + +
-
+
- - - - - - - - -
- #dotlrn.no_class_instances# -
- + + +
+
+ Search classes with : + + + + +
+
-
+ -
+ + + + + + +
+ #dotlrn.no_class_instances# +
+ + +
+ +
Index: openacs-4/packages/dotlrn/www/admin/term.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/term.tcl,v diff -u -r1.12.6.3 -r1.12.6.4 --- openacs-4/packages/dotlrn/www/admin/term.tcl 29 Oct 2004 02:50:47 -0000 1.12.6.3 +++ openacs-4/packages/dotlrn/www/admin/term.tcl 22 Nov 2004 22:23:08 -0000 1.12.6.4 @@ -25,6 +25,7 @@ {department_key ""} {orderby "department_name,asc"} page:optional + {keyword ""} } -properties { classes:multirow } @@ -104,11 +105,17 @@ set query "select_all_classes" set paginator_query "select_all_classes_paginator" } + if {![empty_string_p $department_key]} { append query "_by_department" append paginator_query "_by_department" } +if { ![empty_string_p $keyword] } { + set keyword_clause [db_map select_all_instances_keyword] +} else { + set keyword_clause [db_map select_all_instances_without_keyword] +} if {$term_id == -1} { set title "[_ dotlrn.All_Terms]" set context_bar [list [list terms [_ dotlrn.Terms]] "[_ dotlrn.All_Terms]"] @@ -167,7 +174,7 @@ template::list::create \ -name classes \ -multirow classes \ - -filters { department_key {} term_id {} } \ + -filters { department_key {} term_id {} keyword {} } \ -key class_key \ -page_size 50 \ -page_flush_p t \ 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.1 -r1.7.10.2 --- openacs-4/packages/dotlrn/www/admin/term.xql 30 Sep 2004 17:14:09 -0000 1.7.10.1 +++ openacs-4/packages/dotlrn/www/admin/term.xql 22 Nov 2004 22:23:08 -0000 1.7.10.2 @@ -20,7 +20,8 @@ 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 - where dotlrn_class_instances_full.term_id = :term_id + $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"] @@ -33,7 +34,8 @@ 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 - where dotlrn_class_instances_full.term_id = :term_id + $keyword_clause + and dotlrn_class_instances_full.term_id = :term_id [template::list::orderby_clause -orderby -name "classes"] @@ -45,7 +47,8 @@ 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 - where dotlrn_class_instances_full.term_id = :term_id + $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"] @@ -59,7 +62,8 @@ 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 - where dotlrn_class_instances_full.term_id = :term_id + $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"] @@ -72,7 +76,7 @@ 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 - where 1 = 1 + $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"] @@ -85,6 +89,7 @@ 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"] @@ -96,7 +101,8 @@ 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 - where dotlrn_class_instances_full.department_key = :department_key + $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"] @@ -109,9 +115,21 @@ 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 - where dotlrn_class_instances_full.department_key = :department_key + $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)||'%' + + + + + + where 1 = 1 + + Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/dotlrn/www/admin/toolbar-actions.tcl'. Fisheye: No comparison available. Pass `N' to diff?