Index: openacs-4/packages/lab-report/www/view-lab-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lab-report/www/view-lab-postgresql.xql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/lab-report/www/view-lab-postgresql.xql 12 May 2006 01:34:34 -0000 1.2 +++ openacs-4/packages/lab-report/www/view-lab-postgresql.xql 24 May 2006 12:30:41 -0000 1.3 @@ -19,7 +19,8 @@ SELECT r.report_id, t.template_id, t.name, t.description AS template_desc FROM lrc_template t - LEFT OUTER JOIN lr_report r ON (r.template_id = t.template_id), + LEFT OUTER JOIN lr_report r ON (r.template_id = t.template_id + AND r.author_id = :author_id), lrc_lab_template_map m WHERE m.lab_id = :lab_id AND m.template_id = t.template_id