Index: openacs-4/packages/assessment/www/admin/checks-admin.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/admin/Attic/checks-admin.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/assessment/www/admin/checks-admin.xql	24 Jan 2005 17:45:56 -0000	1.1
+++ openacs-4/packages/assessment/www/admin/checks-admin.xql	28 Jan 2005 20:33:19 -0000	1.2
@@ -3,7 +3,7 @@
 
 <fullquery name="get_aa_checks">
 <querytext>		
-        select am.action_perform,c.inter_item_check_id,c.name,a.name as action_name, am.order_by,c.section_id_from from as_inter_item_checks c,as_actions a, as_action_map am where am.inter_item_check_id = c.inter_item_check_id and am.action_id=a.action_id and c.section_id_from =:section_id and am.action_perform = 'aa' and c.action_p = 't'order by order_by
+        select am.action_perform,c.inter_item_check_id,c.name,a.name as action_name, am.order_by,c.section_id_from from as_inter_item_checks c,as_actions a, as_action_map am where am.inter_item_check_id = c.inter_item_check_id and am.action_id=a.action_id and c.section_id_from =:section_id and am.action_perform = 'aa' and c.action_p = 't'and c.assessment_id=:assessment_id order by order_by
 </querytext>			
 </fullquery>
 
@@ -13,7 +13,7 @@
 	as_inter_item_checks c,as_actions a, as_action_map am where
 	am.inter_item_check_id = c.inter_item_check_id and am.action_id=a.action_id
 	and c.section_id_from =:section_id and am.action_perform = 'i' and c.action_p
-	= 't' order by order_by
+	= 't' and c.assessment_id=:assessment_id order by order_by
 </querytext>			
 </fullquery>
 
@@ -23,15 +23,15 @@
 	as_inter_item_checks c,as_actions a, as_action_map am where
 	am.inter_item_check_id = c.inter_item_check_id and am.action_id=a.action_id
 	and c.section_id_from =:section_id and am.action_perform = 'm' and c.action_p
-	= 't' order by order_by
+	= 't' and c.assessment_id=:assessment_id order by order_by
 </querytext>			
 </fullquery>
 
 <fullquery name="get_branches">
 <querytext>		
 	select c.name,c.inter_item_check_id,c.section_id_to,(select cr.title from
 	cr_revisions cr where cr.revision_id=c.section_id_to) as sname  from
-	as_inter_item_checks c where c.action_p='f' and c.section_id_from=:section_id
+	as_inter_item_checks c where c.action_p='f' and c.section_id_from=:section_id and c.assessment_id=:assessment_id
 </querytext>			
 </fullquery>