Index: openacs-4/packages/lab-report-central/www/lab-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lab-report-central/www/lab-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/lab-report-central/www/lab-postgresql.xql	24 Apr 2006 11:27:04 -0000	1.1
+++ openacs-4/packages/lab-report-central/www/lab-postgresql.xql	27 Apr 2006 04:34:34 -0000	1.2
@@ -15,8 +15,12 @@
 
    <fullquery name="rt">
      <querytext>
-       SELECT template_id, name AS template_name, description AS template_desc
-       FROM lrc_template
+       SELECT t.template_id, t.name AS template_name,
+           t.description AS template_desc
+       FROM lrc_template t, lrc_lab_template_map m
+       WHERE m.lab_id = :lab_id
+       AND m.template_id = t.template_id
+       AND t.package_id = :package_id
      </querytext>
    </fullquery>