Index: openacs-4/packages/lab-report-central/tcl/lab-report-central-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lab-report-central/tcl/lab-report-central-procs-postgresql.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/lab-report-central/tcl/lab-report-central-procs-postgresql.xql	24 Apr 2006 11:27:04 -0000	1.1
+++ openacs-4/packages/lab-report-central/tcl/lab-report-central-procs-postgresql.xql	27 Apr 2006 04:34:33 -0000	1.2
@@ -78,4 +78,11 @@
      </querytext>
    </fullquery>
 
+   <fullquery name="lab_report_central::unmapped_templates_get_options.templates">
+     <querytext>
+       SELECT t.name, t.template_id
+       FROM lrc_template t
+       WHERE t.template_id NOT IN (select template_id from lrc_lab_template_map where lab_id = :lab_id)
+     </querytext>
+   </fullquery>
 </queryset>