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.3 -r1.4
--- openacs-4/packages/lab-report-central/www/lab-postgresql.xql	30 Apr 2006 12:01:31 -0000	1.3
+++ openacs-4/packages/lab-report-central/www/lab-postgresql.xql	24 Aug 2006 10:56:57 -0000	1.4
@@ -16,7 +16,9 @@
    <fullquery name="rt">
      <querytext>
        SELECT t.template_id, t.name AS template_name,
-           t.description AS template_desc
+           t.description AS template_desc,
+           to_char(m.start_date, 'DD Month, YYYY') AS release_date,
+           to_char(m.end_date, 'DD Month, YYYY') AS submission_date
        FROM lrc_template t, lrc_lab_template_map m
        WHERE m.lab_id = :lab_id
        AND m.template_id = t.template_id