Index: openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql,v diff -u -r1.3.2.2 -r1.3.2.3 --- openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql 29 Apr 2004 08:13:51 -0000 1.3.2.2 +++ openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql 29 Apr 2004 08:22:50 -0000 1.3.2.3 @@ -173,7 +173,7 @@ select b.bug_id, b.bug_number, b.summary, - upper(b.summary) as upper_summary, + lower(b.summary) as lower_summary, b.comment_content, b.comment_format, b.component_id, @@ -183,9 +183,9 @@ submitter.first_names as submitter_first_names, submitter.last_name as submitter_last_name, submitter.email as submitter_email, - upper(submitter.first_names) as upper_submitter_first_names, - upper(submitter.last_name) as upper_submitter_last_name, - upper(submitter.email) as upper_submitter_email, + lower(submitter.first_names) as lower_submitter_first_names, + lower(submitter.last_name) as lower_submitter_last_name, + lower(submitter.email) as lower_submitter_email, st.pretty_name as pretty_state, st.short_name as state_short_name, st.state_id, Index: openacs-4/packages/bug-tracker/tcl/bug-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-procs-postgresql.xql,v diff -u -r1.4.2.2 -r1.4.2.3 --- openacs-4/packages/bug-tracker/tcl/bug-procs-postgresql.xql 29 Apr 2004 08:13:52 -0000 1.4.2.2 +++ openacs-4/packages/bug-tracker/tcl/bug-procs-postgresql.xql 29 Apr 2004 08:22:50 -0000 1.4.2.3 @@ -160,7 +160,7 @@ select b.bug_id, b.bug_number, b.summary, - upper(b.summary) as upper_summary, + lower(b.summary) as lower_summary, b.comment_content, b.comment_format, b.component_id, @@ -170,9 +170,9 @@ submitter.first_names as submitter_first_names, submitter.last_name as submitter_last_name, submitter.email as submitter_email, - upper(submitter.first_names) as upper_submitter_first_names, - upper(submitter.last_name) as upper_submitter_last_name, - upper(submitter.email) as upper_submitter_email, + lower(submitter.first_names) as lower_submitter_first_names, + lower(submitter.last_name) as lower_submitter_last_name, + lower(submitter.email) as lower_submitter_email, st.pretty_name as pretty_state, st.short_name as state_short_name, st.state_id, Index: openacs-4/packages/bug-tracker/tcl/bug-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-procs.tcl,v diff -u -r1.10.2.2 -r1.10.2.3 --- openacs-4/packages/bug-tracker/tcl/bug-procs.tcl 29 Apr 2004 08:13:52 -0000 1.10.2.2 +++ openacs-4/packages/bug-tracker/tcl/bug-procs.tcl 29 Apr 2004 08:22:50 -0000 1.10.2.3 @@ -751,13 +751,13 @@ } summary { label "Summary" - orderby_asc {upper_summary asc, summary asc, bug_number asc} - orderby_desc {upper_summary desc, summary desc, bug_number desc} + orderby_asc {lower_summary asc, summary asc, bug_number asc} + orderby_desc {lower_summary desc, summary desc, bug_number desc} } submitter { label "Submitter" - orderby_asc {upper_submitter_first_names asc, upper_submitter_last_name asc, bug_number asc} - orderby_desc {upper_submitter_first_names desc, upper_submitter_last_name desc, bug_number desc} + orderby_asc {lower_submitter_first_names asc, lower_submitter_last_name asc, bug_number asc} + orderby_desc {lower_submitter_first_names desc, lower_submitter_last_name desc, bug_number desc} } }