Index: openacs-4/packages/news-portlet/www/news-portlet-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news-portlet/www/Attic/news-portlet-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/news-portlet/www/news-portlet-oracle.xql	6 Apr 2002 18:01:38 -0000	1.1
+++ openacs-4/packages/news-portlet/www/news-portlet-oracle.xql	12 Apr 2002 08:11:15 -0000	1.2
@@ -19,6 +19,8 @@
             where news_items_approved.publish_date < sysdate
             and (news_items_approved.archive_date >= sysdate or news_items_approved.archive_date is null)
             and news_items_approved.package_id in ([join $list_of_instance_ids ", "])
+            order by parent_name,
+                     news_items_approved.publish_title
         </querytext>
     </fullquery>