Forum .LRN Q&A: Fix for fs-contents-portlet (postgres)

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
 
Collapse
Posted by Arjun Sanyal on
fixed. thanks, deds!