Index: openacs-4/packages/acs-admin/www/apm/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/apm/index-oracle.xql,v
diff -u -N -r1.6 -r1.7
--- openacs-4/packages/acs-admin/www/apm/index-oracle.xql	10 Mar 2003 12:01:54 -0000	1.6
+++ openacs-4/packages/acs-admin/www/apm/index-oracle.xql	27 Oct 2014 16:38:51 -0000	1.7
@@ -13,8 +13,9 @@
 <fullquery name="apm_table">      
       <querytext>
 
-        select   v.version_id, v.package_key, t.pretty_name, v.version_name, v.enabled_p,
-                 v.installed_p, v.distribution_uri,
+        select   v.version_id, v.package_key, t.pretty_name, v.version_name, 
+	         to_char(v.release_date, 'YYYY-MM-DD') as release_date
+	         v.enabled_p, v.installed_p, v.distribution_uri,
             (select count(*) from apm_package_versions v2
              where v2.package_key = v.package_key
              and   v2.installed_p = 't'
@@ -26,8 +27,8 @@
              end as tarball_p
         from    apm_package_versions v, apm_package_types t
         where  t.package_key = v.package_key
-        [ad_dimensional_sql $dimensional_list where and]
-        [ad_order_by_from_sort_spec $orderby $table_def]
+        $filter_where_clause
+        [template::list::orderby_clause -name package_list -orderby]
 
       </querytext>
 </fullquery>