Index: openacs-4/packages/curriculum-central/www/admin/faculty-depts-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum-central/www/admin/faculty-depts-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/curriculum-central/www/admin/faculty-depts-postgresql.xql	20 Nov 2005 23:51:11 -0000	1.1
+++ openacs-4/packages/curriculum-central/www/admin/faculty-depts-postgresql.xql	21 Nov 2005 05:27:59 -0000	1.2
@@ -18,6 +18,7 @@
 	       WHERE user_id = hod_id) AS hod
 	   FROM cc_department
            WHERE faculty_id = :faculty_id
+	   [template::list::orderby_clause -orderby -name "depts"]
      </querytext>
    </fullquery>
 </queryset>
Index: openacs-4/packages/curriculum-central/www/admin/faculty-depts.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum-central/www/admin/faculty-depts.tcl,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/curriculum-central/www/admin/faculty-depts.tcl	21 Nov 2005 04:28:38 -0000	1.3
+++ openacs-4/packages/curriculum-central/www/admin/faculty-depts.tcl	21 Nov 2005 05:27:59 -0000	1.4
@@ -60,7 +60,8 @@
 	department_name {orderby {lower(department_name)}}
 	hod {orderby {lower(hod)}}
     } \
-    -pass_properties {faculty_id}
+    -pass_properties {faculty_id} \
+    -filters { faculty_id {} }
 
 db_multirow depts get_depts {}