Index: openacs-4/packages/assessment/tcl/as-checks-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/tcl/as-checks-procs-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/assessment/tcl/as-checks-procs-postgresql.xql	27 Jan 2005 18:07:37 -0000	1.2
+++ openacs-4/packages/assessment/tcl/as-checks-procs-postgresql.xql	28 Jan 2005 20:31:32 -0000	1.3
@@ -17,14 +17,14 @@
 
 <fullquery name="as::assessment::check::copy_checks.get_checks">
       <querytext>
-	select inter_item_check_id,action_p,check_sql,postcheck_p,section_id_from,section_id_to,item_id,name,description from as_inter_item_checks where section_id_from=:section_id
+	select inter_item_check_id,action_p,check_sql,postcheck_p,section_id_from,section_id_to,item_id,name,description,assessment_id from as_inter_item_checks where section_id_from=:section_id and assessment_id=:assessment_id
       </querytext>
 </fullquery>
 
 <fullquery name="as::assessment::check::copy_checks.copy_check">
       <querytext>
 
- 	select as_inter_item_check__new (null,:action_p,:section_id_from,null,:check_sql,:name,:description,:postcheck_p,null,:user_id,null)	
+ 	select as_inter_item_check__new (null,:action_p,:section_id_from,null,:check_sql,:name,:description,:postcheck_p,null,:user_id,null,:assessment_id)	
 
       </querytext>
 </fullquery>
@@ -34,5 +34,10 @@
 	select as_inter_item_check__delete (:check_id)
       </querytext>
 </fullquery>
+<fullquery name="as::assessment::check::intervals.intervals">
+      <querytext>
+      select to_date(now(),'YYYY-MM-DD') as today, to_date(to_date(now(),'YYYY-MM-DD')-1,'YYYY-MM-DD') as yesterday,  to_date (to_date(now(),'YYYY-MM-DD')-2,'YYYY-MM-DD') as two_days,to_date (to_date(now(),'YYYY-MM-DD')-7,'YYYY-MM-DD') as last_week, to_date (to_date(now(),'YYYY-MM-DD')-30,'YYYY-MM-DD') as last_month 
+      </querytext>
+</fullquery>
 
 </queryset>
\ No newline at end of file