Index: openacs-4/packages/contacts/lib/contact-complaint-list.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/lib/contact-complaint-list.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/contacts/lib/contact-complaint-list.xql	11 Aug 2005 14:14:58 -0000	1.2
+++ openacs-4/packages/contacts/lib/contact-complaint-list.xql	5 Oct 2005 08:42:13 -0000	1.3
@@ -5,11 +5,12 @@
 <fullquery name="get_complaints">
     <querytext>
 	select 
-		cct.*
+		cct.*, cr.title, cr.description
 	from
-		contact_complaint_tracking cct, cr_items ci
+		contact_complaint_tracking cct, cr_items ci, cr_revisions cr
 	where
 		ci.latest_revision = cct.complaint_id
+	        and cr.revision_id = cct.complaint_id
 		[template::list::filter_where_clauses -and -name complaint] 
     </querytext>
 </fullquery>