SELECT
t.parent_id as project_item_id
FROM
pm_tasks_revisionsx t, cr_items i
WHERE
i.item_id = t.item_id and
t.revision_id = :task_revision_id
SELECT
t.item_id,
t.title as task_title,
t.description,
to_char(t.end_date,'Mon DD ''YY') as end_date,
to_char(t.earliest_start,'Mon DD ''YY') as earliest_start,
to_char(t.earliest_start,'J') as earliest_start_j,
to_char(t.earliest_finish,'Mon DD ''YY') as earliest_finish,
to_char(t.latest_start,'Mon DD ''YY') as latest_start,
to_char(t.latest_start,'J') as latest_start_j,
to_char(t.latest_finish,'Mon DD ''YY') as latest_finish,
to_char(current_date,'J') as today_j,
t.estimated_hours_work,
t.estimated_hours_work_min,
t.estimated_hours_work_max,
t.percent_complete,
i.live_revision,
p.first_names || ' ' || p.last_name as creation_user
FROM
pm_tasks_revisionsx t,
cr_items i,
persons p
WHERE
t.item_id = :task_id and
t.revision_id = :task_revision_id and
t.item_id = i.item_id and
t.creation_user = p.person_id
SELECT
t.item_id,
t.revision_id,
i.live_revision,
t.title as task_title,
t.description || ' -- ' || p.first_names || ' ' || p.last_name as description,
to_char(t.end_date,'MM/DD/YYYY') as end_date,
t.percent_complete,
t.estimated_hours_work_min,
t.estimated_hours_work_max,
t.actual_hours_worked
FROM
pm_tasks_revisionsx t, cr_items i, persons p
WHERE
t.item_id = :task_id and
t.item_id = i.item_id and
t.creation_user = p.person_id
[template::list::orderby_clause -name revisions -orderby]
SELECT
t.title as task_title,
to_char(t.end_date,'MM/DD/YYYY') as end_date,
t.percent_complete,
i.live_revision,
d.parent_task_id,
d.dependency_type
FROM
pm_tasks_revisionsx t, cr_items i, pm_task_dependency d
WHERE
d.task_id = :task_id and
d.parent_task_id = t.item_id and
t.revision_id = i.live_revision and
t.item_id = i.item_id
[template::list::orderby_clause -name dependency -orderby]
SELECT
t.title as task_title,
to_char(t.end_date,'MM/DD/YYYY') as end_date,
t.percent_complete,
i.live_revision,
d.parent_task_id,
d.dependency_type,
d.task_id as d_task_id
FROM
pm_tasks_revisionsx t, cr_items i, pm_task_dependency d
WHERE
d.task_id = t.item_id and
d.parent_task_id = :task_id and
t.revision_id = i.live_revision and
t.item_id = i.item_id
[template::list::orderby_clause -name dependency2 -orderby]
select
r.one_line,
u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as user_info,
r.role_id
from
pm_task_assignment a,
cc_users u,
pm_roles r
where
a.task_id = :task_id and
u.party_id = a.party_id and
a.role_id = r.role_id
SELECT
x.task_id_1 as x_task_id,
r.title,
to_char(r.earliest_start,'YYYY-MM-DD HH24:MI') as earliest_start,
r.earliest_start - current_date as days_to_earliest_start,
to_char(r.earliest_start,'J') as earliest_start_j,
to_char(r.earliest_finish,'YYYY-MM-DD HH24:MI') as earliest_finish,
r.earliest_finish - current_date as days_to_earliest_finish,
to_char(r.latest_start,'YYYY-MM-DD HH24:MI') as latest_start,
r.latest_start - current_date as days_to_latest_start,
to_char(r.latest_start,'J') as latest_start_j,
to_char(current_date,'J') as today_j,
to_char(r.latest_finish,'YYYY-MM-DD HH24:MI') as latest_finish,
r.latest_finish - current_date as days_to_latest_finish
FROM
pm_task_xref x, pm_tasks_revisionsx r, cr_items i
WHERE
x.task_id_2 = :task_id and
x.task_id_2 = r.item_id and
r.revision_id = i.live_revision
UNION
SELECT
x2.task_id_2 as x_task_id,
r2.title,
to_char(r2.earliest_start,'YYYY-MM-DD HH24:MI') as earliest_start,
r2.earliest_start - current_date as days_to_earliest_start,
to_char(r2.earliest_start,'J') as earliest_start_j,
to_char(r2.earliest_finish,'YYYY-MM-DD HH24:MI') as earliest_finish,
r2.earliest_finish - current_date as days_to_earliest_finish,
to_char(r2.latest_start,'YYYY-MM-DD HH24:MI') as latest_start,
r2.latest_start - current_date as days_to_latest_start,
to_char(r2.latest_start,'J') as latest_start_j,
to_char(current_date,'J') as today_j,
to_char(r2.latest_finish,'YYYY-MM-DD HH24:MI') as latest_finish,
r2.latest_finish - current_date as days_to_latest_finish
FROM
pm_task_xref x2, pm_tasks_revisionsx r2, cr_items i2
WHERE
x2.task_id_1 = :task_id and
x2.task_id_1 = r2.item_id and
i2.live_revision = r2.revision_id