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.1 -r1.2
--- openacs-4/packages/contacts/lib/contact-complaint-list.xql	8 Aug 2005 21:50:57 -0000	1.1
+++ openacs-4/packages/contacts/lib/contact-complaint-list.xql	11 Aug 2005 14:14:58 -0000	1.2
@@ -5,11 +5,11 @@
 <fullquery name="get_complaints">
     <querytext>
 	select 
-		*
+		cct.*
 	from
-		contact_complaint_tracking
+		contact_complaint_tracking cct, cr_items ci
 	where
-		1 = 1
+		ci.latest_revision = cct.complaint_id
 		[template::list::filter_where_clauses -and -name complaint] 
     </querytext>
 </fullquery>