Index: openacs-4/packages/dotlrn-research/www/research-portlet-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-research/www/Attic/research-portlet-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/dotlrn-research/www/research-portlet-oracle.xql	25 Feb 2002 22:43:48 -0000	1.2
+++ openacs-4/packages/dotlrn-research/www/research-portlet-oracle.xql	5 Mar 2002 00:41:01 -0000	1.3
@@ -5,25 +5,17 @@
 
 <fullquery name="select_files">
     <querytext>
-        select cr_items.item_id as file_id,
-               cr_items.name as name,
-               cr_items.live_revision as file_live_rev,
-               cr_revisions.mime_type as type,
-               to_char(acs_objects.last_modified,'YYYY-MM-DD HH24:MI') as last_modified,
-               cr_revisions.content_length as content_size,
-               (select site_node.url(site_nodes.node_id)
-                from site_nodes
-                where site_nodes.object_id = file_storage.get_package_id(cr_items.item_id)) as url
-        from cr_items,
-             cr_revisions,
-             acs_objects,
-             acs_permissions
-        where cr_items.content_type = 'file_storage_object'
-        and cr_items.item_id = acs_objects.object_id
-        and cr_items.live_revision = cr_revisions.revision_id
-        and acs_permissions.object_id = cr_items.live_revision
-        and acs_permissions.grantee_id = :party_id
-        and acs_permissions.privilege = 'read'
+        select fs_files.file_id,
+               fs_files.name,
+               fs_files.live_revision,
+               fs_files.type,
+               to_char(fs_files.last_modified, 'Mon DD YYYY HH24:MI') as last_modified,
+               fs_files.content_size,
+               fs_files.url
+        from dotlrn_research_papers,
+             fs_files
+        where dotlrn_research_papers.community_id = :community_id
+        and dotlrn_research_papers.file_id = fs_files.live_revision
         order by name
     </querytext>
 </fullquery>