Index: openacs-4/packages/file-storage/lib/folder-links.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/lib/Attic/folder-links.xql,v diff -u -N --- openacs-4/packages/file-storage/lib/folder-links.xql 21 Nov 2017 11:20:13 -0000 1.3 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,47 +0,0 @@ - - - - - - select subscr_id, short_name, folder_id - from fs_rss_subscrs - where folder_id = :folder_id - order by upper(short_name) - - - - - - - select fs_objects.object_id, - fs_objects.name, - fs_objects.live_revision, - fs_objects.type, - fs_objects.pretty_type, - to_char(fs_objects.last_modified, 'YYYY-MM-DD HH24:MI:SS') as last_modified_ansi, - fs_objects.content_size, - fs_objects.url, - fs_objects.sort_key, - fs_objects.file_upload_name, - coalesce(fs_objects.title,fs_objects.name) as title, - -- fs_objects.description, - case - when :folder_path is null - then fs_objects.file_upload_name - else :folder_path || '/' || fs_objects.file_upload_name - end as file_url --, --- fs_objects.html_description - from fs_objects - where fs_objects.parent_id = :folder_id - $permission_clause --- and fs_objects.approved_p = 't' --- and ((fs_objects.active_date_start is null) or (current_timestamp >= fs_objects.active_date_start)) --- and ((fs_objects.active_date_end is null) or (current_timestamp <= fs_objects.active_date_end)) - $object_list_where - order by fs_objects.sort_key, fs_objects.name --- order by fs_objects.sort_key, fs_objects.order_n, fs_objects.name - - - - -