Index: openacs-4/packages/file-storage/tcl/file-storage-rss-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/tcl/file-storage-rss-procs-oracle.xql,v diff -u -r1.2 -r1.2.16.1 --- openacs-4/packages/file-storage/tcl/file-storage-rss-procs-oracle.xql 13 Jan 2005 13:58:12 -0000 1.2 +++ openacs-4/packages/file-storage/tcl/file-storage-rss-procs-oracle.xql 5 Oct 2021 10:04:44 -0000 1.2.16.1 @@ -10,38 +10,6 @@ connect by prior item_id = parent_id start with item_id = :folder_id) - + - - - select * from ( - select o.object_id as item_id, - o.title, - o.name, - o.file_upload_name, - o.type, - o.content_size, - to_char(o.last_modified,'YYYY-MM-DD HH24:MI:SS') as publish_date_ansi, - r.description, - r.revision_id - from fs_objects o, - cr_revisions r - where $parent_clause - and type != 'folder' - and $revisions_clause - order by last_modified desc - ) where rownum < :max_items + 1 - - - - - - select (max(last_modified)-to_date('1970-01-01','YYYY-MM-DD'))*60*60*24 as last_update - from fs_rss_subscrs s, fs_objects f - where s.subscr_id = :summary_context_id - and f.parent_id = s.folder_id - and f.type != 'folder' - - -