SELECT
t.process_task_id as process_tid,
t.one_line,
t.description,
t.estimated_hours_work,
t.estimated_hours_work_min,
t.estimated_hours_work_max,
d.dependency_id,
d.parent_task_id as process_parent_task
FROM
pm_process_task t LEFT JOIN pm_process_task_dependency d ON t.process_task_id = d.process_task_id
WHERE
t.process_id = :process_id
ORDER BY
t.process_task_id
select
current_timestamp
select
t.task_revision_id,
t.title as my_task_title,
t.description as my_description,
t.mime_type as my_mime_type,
to_char(t.end_date,'YYYY MM DD') as my_end_date,
t.percent_complete as my_percent_complete,
t.estimated_hours_work as my_estimated_work,
t.estimated_hours_work_min as my_estimated_work_min,
t.estimated_hours_work_max as my_estimated_work_max,
t.actual_hours_worked as my_actual_hours_worked,
d.parent_task_id as my_dependency
FROM
pm_tasks_revisionsx t,
cr_items i LEFT JOIN pm_task_dependency d ON i.item_id = d.task_id
WHERE
t.item_id in ([join $task_id ","]) and
t.revision_id = i.live_revision
SELECT
p.project_id
FROM
pm_projectsx p, cr_items i
WHERE
p.item_id = :project_item_id and
p.revision_id = i.live_revision
select
short_name,
description
FROM
pm_task_dependency_types
ORDER BY
short_name
SELECT
r.item_id,
r.title as task_title
FROM
pm_tasks_revisionsx r,
cr_items i,
pm_tasks t,
pm_task_status s
WHERE
r.parent_id = :project_item_id and
r.revision_id = i.live_revision and
i.item_id = t.task_id and
t.status = s.status_id and
s.status_type = 'o'
UNION
SELECT
r.item_id,
r.title as task_title
FROM
pm_tasks_revisionsx r,
cr_items i,
pm_tasks t
WHERE
r.parent_id = :project_item_id and
r.revision_id = i.live_revision and
i.item_id = t.task_id and
t.task_id in ([join $my_dependencies ","])
ORDER BY
task_title
select
item_id
FROM
pm_tasks_revisionsx
WHERE
revision_id = :this_revision_id