Index: openacs-4/packages/acs-admin/www/apm/packages/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/apm/packages/index-oracle.xql,v diff -u -N -r1.2.32.1 -r1.2.32.2 --- openacs-4/packages/acs-admin/www/apm/packages/index-oracle.xql 23 Oct 2020 17:03:05 -0000 1.2.32.1 +++ openacs-4/packages/acs-admin/www/apm/packages/index-oracle.xql 3 Apr 2021 14:10:06 -0000 1.2.32.2 @@ -3,32 +3,32 @@ oracle8.1.6 - - + + - select count(*) - from cr_revisions - where revision_id = (select content_item.get_latest_revision(item_id) + select count(*) + from cr_revisions + where revision_id = (select content_item.get_latest_revision(item_id) from apm_package_versions - where version_id = :version_id) + where version_id = :version_id) - + - - - - - select '[cr_fs_path]' || filename as content, + + + + + select '[cr_fs_path]' || filename as content, '[set storage_type file]' as storage_type - from cr_revisions - where revision_id = (select content_item.get_latest_revision(item_id) + from cr_revisions + where revision_id = (select content_item.get_latest_revision(item_id) from apm_package_versions - where version_id = :version_id) + where version_id = :version_id) - + - +