select
t.task_revision_id,
t.title as task_title,
t.item_id,
t.description,
t.name,
t.parent_id,
to_char(t.end_date,'YYYY MM DD') as end_date,
t.percent_complete
FROM
pm_tasks_revisionsx t, cr_items i
WHERE
t.item_id in ([join $task_id ", "]) and
t.revision_id = i.live_revision
select
t.revision_id,
t.title as task_title,
t.item_id,
t.description,
t.name,
t.parent_id,
to_char(t.end_date,'Mon DD ''YY') as end_date,
t.percent_complete
FROM
pm_tasks_revisionsx t, cr_items i
WHERE
t.revision_id in ([join $task_revisions ", "]) and
i.item_id = t.item_id
select
item_id
FROM
pm_tasks_revisionsx
WHERE
revision_id = :tr
select
short_name,
description
FROM
pm_task_constraint_types
ORDER BY
short_name
select
r.item_id, r.title as task_title
FROM
pm_tasks_revisionsx r, cr_items i
WHERE
r.parent_id = :project_item_id and
r.revision_id = i.live_revision
ORDER BY
upper(r.title)
INSERT INTO pm_task_constraints
(constraint_id, task_id, parent_task_id, const_type)
VALUES
(:const_id, :tsk_id, :parent_tsk_id, :type_id)
select
parent_id
FROM
pm_tasks_revisionsx
WHERE
revision_id = '[lindex $task_revisions 0]'