Index: openacs-4/packages/news/www/admin/revision-add.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/admin/revision-add.xql,v
diff -u -N -r1.4 -r1.5
--- openacs-4/packages/news/www/admin/revision-add.xql	22 Dec 2009 22:24:02 -0000	1.4
+++ openacs-4/packages/news/www/admin/revision-add.xql	15 Nov 2017 14:12:45 -0000	1.5
@@ -1,6 +1,27 @@
 <?xml version="1.0"?>
 <queryset>
 
+  <fullquery name="item">      
+      <querytext>      
+select
+    item_id, 
+    package_id,   
+    revision_id,
+    publish_title,
+    publish_lead,
+    publish_body,
+    publish_format,
+    to_char(publish_date, 'YYYY-MM-DD') as publish_date,
+    publish_body,
+    to_char(archive_date, 'YYYY-MM-DD') as archive_date
+    status
+from   
+    news_item_full_active    
+where  
+    item_id = :item_id
+      </querytext>
+  </fullquery>
+  
   <fullquery name="news_item_info">      
       <querytext>