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 -r1.8 -r1.9 --- openacs-4/packages/acs-admin/www/apm/index-oracle.xql 7 Aug 2017 23:47:45 -0000 1.8 +++ openacs-4/packages/acs-admin/www/apm/index-oracle.xql 3 Sep 2024 15:37:29 -0000 1.9 @@ -2,20 +2,20 @@ oracle8.1.6 - - - + + + select email from parties where party_id = :user_id - + - - + + - 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 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' @@ -30,7 +30,7 @@ $filter_where_clause [template::list::orderby_clause -name package_list -orderby] - +