Index: openacs-4/packages/weblogger-portlet/www/weblogger-portlet-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/weblogger-portlet/www/weblogger-portlet-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/weblogger-portlet/www/weblogger-portlet-oracle.xql	22 Aug 2003 11:18:28 -0000	1.2
+++ openacs-4/packages/weblogger-portlet/www/weblogger-portlet-oracle.xql	17 Oct 2003 00:39:55 -0000	1.3
@@ -5,26 +5,28 @@
 
     <fullquery name="entries">
         <querytext>
-		    select entry_id,
-                           acs_object.name(apm_package.parent_id(e.package_id)) as parent_name,
+		    select e.entry_id,
+                           acs_object.name(apm_package.parent_id(p.package_id)) as parent_name,
                            (select site_node.url(site_nodes.node_id)
-                            from site_nodes
-                            where site_nodes.object_id = e.package_id) as base_url,
-		           title,
-                           content,
-		           p.first_names as poster_first_names,
-		           p.last_name as poster_last_name,
-		           to_char(posted_date , 'HH24:MI') as posted_time_pretty,
-		    from   pinds_blog_entries e,
+                            from   site_nodes
+                            where  site_nodes.object_id = p.package_id) as base_url,
+		           e.title,
+                           e.content,
+		           u.first_names as poster_first_names,
+		           u.last_name as poster_last_name,
+		           to_char(e.posted_date , 'HH24:MI') as posted_time_pretty,
+                           p.package_id
+		    from   apm_packages p,
+                           pinds_blog_entries e,
 		           acs_objects o,
-		           persons p
-		    where  e.entry_id = o.object_id
-		    and    p.person_id = o.creation_user
-		    and    package_id = :package_id
-		    and    $date_clause
-		    and    draft_p = 'f'
-		    and    deleted_p = 'f'
-		    order  by entry_date desc, posted_date desc
+		           all_users u
+		    where  p.package_id in ([join $list_of_package_ids ", "])
+                    and    e.package_id (+) = p.package_id
+                    and    o.object_id (+) = e.entry_id
+		    and    u.user_id (+) = o.creation_user 
+		    and    e.draft_p (+) = 'f'
+		    and    e.deleted_p (+) = 'f'
+		    order  by p.package_id asc, e.entry_date desc, e.posted_date desc
         </querytext>
     </fullquery>