Forum .LRN Q&A: Fix for fs-contents-portlet (postgres)
Posted by Deds Castillo on 08/12/02 08:23 AM
The query select_folder_contents in /packages/fs-portlet/www/fs-contents-portlet-postgresql.xql still has "dot" on some function calls. They should be changed to "double underscore". Correct query should look like:
select file_storage__get_package_id(fs_objects.object_id) as package_id, (CASE WHEN fs_objects.type = 'url' THEN (select site_node__url(site_nodes.node_id) from site_nodes where site_nodes.object_id = file_storage__get_package_id(fs_objects.parent_id)) ELSE (select site_node__url(site_nodes.node_id) from site_nodes where site_nodes.object_id = file_storage__get_package_id(fs_objects.object_id)) END) as url, fs_objects.object_id, fs_objects.name, fs_objects.live_revision, fs_objects.type, fs_objects.content_size from fs_objects where fs_objects.parent_id in ([join $list_of_folder_ids ", "]) and 't' = acs_permission__permission_p(fs_objects.object_id, :user_id, 'read') order by fs_objects.parent_id, fs_objects.sort_key, fs_objects.name
2: Response to Fix for fs-contents-portlet (postgres) (response to 1)
Posted by Arjun Sanyal on 08/12/02 03:41 PM
fixed. thanks, deds!