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.5 -r1.6
--- openacs-4/packages/dotlrn-research/www/research-portlet-oracle.xql	29 Mar 2002 19:40:28 -0000	1.5
+++ openacs-4/packages/dotlrn-research/www/research-portlet-oracle.xql	19 Apr 2002 17:19:25 -0000	1.6
@@ -3,21 +3,23 @@
 <queryset>
 <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
-<fullquery name="select_files">
-    <querytext>
-        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>
+    <fullquery name="select_files">
+        <querytext>
+            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,
+                   (select site_node.url(site_nodes.node_id)
+                    from site_nodes
+                    where site_nodes.object_id = file_storage.get_package_id(fs_files.file_id)) as 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>
 
 </queryset>