Index: openacs-4/contrib/packages/project-manager/www/task-assign-add-edit-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-assign-add-edit-postgresql.xql,v
diff -u -r1.7 -r1.8
--- openacs-4/contrib/packages/project-manager/www/task-assign-add-edit-postgresql.xql 27 Apr 2004 00:49:29 -0000 1.7
+++ openacs-4/contrib/packages/project-manager/www/task-assign-add-edit-postgresql.xql 14 May 2004 23:08:57 -0000 1.8
@@ -16,23 +16,39 @@
+ select
+ title
+ FROM
+ pm_projects p, cr_revisions r, cr_items i
+ WHERE
+ r.item_id = :project_item_id and
+ i.item_id = r.item_id and
+ p.project_id = i.live_revision and
+ p.project_id = r.revision_id
+
select
- title as one_line,
- description,
- item_id,
- estimated_hours_work,
- estimated_hours_work_min,
- estimated_hours_work_max,
- to_char(earliest_start, 'YYYY-MM-DD HH24:MI:SS') as earliest_start_ansi,
- to_char(earliest_finish, 'YYYY-MM-DD HH24:MI:SS') as earliest_finish_ansi,
- to_char(latest_start, 'YYYY-MM-DD HH24:MI:SS') as latest_start_ansi,
- to_char(latest_finish, 'YYYY-MM-DD HH24:MI:SS') as latest_finish_ansi
+ t.title as one_line,
+ t.description,
+ t.item_id,
+ t.estimated_hours_work,
+ t.estimated_hours_work_min,
+ t.estimated_hours_work_max,
+ to_char(t.earliest_start, 'YYYY-MM-DD HH24:MI:SS') as earliest_start_ansi,
+ to_char(t.earliest_finish, 'YYYY-MM-DD HH24:MI:SS') as earliest_finish_ansi,
+ to_char(t.latest_start, 'YYYY-MM-DD HH24:MI:SS') as latest_start_ansi,
+ to_char(t.latest_finish, 'YYYY-MM-DD HH24:MI:SS') as
+ latest_finish_ansi,
+ proj_rev.title as project_name
FROM
- pm_tasks_revisionsx t
+ pm_tasks_revisionsx t,
+ cr_items proj,
+ cr_revisions proj_rev
WHERE
- revision_id in ([join $revisions ","])
+ t.revision_id in ([join $revisions ","]) and
+ t.parent_id = proj.item_id and
+ proj.live_revision = proj_rev.revision_id
ORDER BY
item_id
@@ -122,19 +138,4 @@
process_task_id = :ptid
-
-
-
- select
- title
- FROM
- pm_projects p, cr_revisions r, cr_items i
- WHERE
- r.item_id = :project_item_id and
- i.item_id = r.item_id and
- p.project_id = i.live_revision and
- p.project_id = r.revision_id
-
-
-