postgresql7.1
select
item_id,
content_type
from
cr_items
where parent_id = :project_item_id
select
sum(t.actual_hours_worked) as actual_hours_completed,
sum(t.estimated_hours_work) as estimated_hours_total,
to_char(current_timestamp,'J') as today_j
from
pm_tasks_revisionsx t, cr_items i
where
t.item_id in ([join $task_list ", "]) and
i.live_revision = t.revision_id
select
t.actual_hours_worked as worked,
t.estimated_hours_work as to_work,
t.item_id as my_iid,
to_char(end_date,'J') as task_deadline_j
from
pm_tasks_revisionsx t, cr_items i
where
t.item_id in ([join $task_list ", "]) and
i.live_revision = t.revision_id
select
d.dependency_id,
d.task_id as task_item_id,
d.parent_task_id,
d.dependency_type
from
pm_task_dependency d
where
d.task_id in ([join $task_list ", "])
select
to_char(planned_start_date,'J') as start_date_j,
to_char(planned_end_date,'J') as end_date_j
from
pm_projects
where
project_id = (select live_revision from cr_items where item_id = :project_item_id)
update
pm_projects
set
actual_hours_completed = :actual_hours_completed,
estimated_hours_total = :estimated_hours_total,
earliest_finish_date = 'J[expr floor([set max_earliest_finish])]',
latest_finish_date = 'J[expr ceil([set min_latest_start])]'
where
project_id = (select live_revision from cr_items where item_id = :project_item_id)
select
parent_id
from
cr_items
where
item_id = :my_item_id
select pm_project__get_root_folder (:package_id, 'f')
update
pm_tasks_revisions
set
earliest_start = 'J[expr ceil( [set earliest_start($task_item)])]',
earliest_finish = 'J[expr ceil( [set earliest_finish($task_item)])]',
latest_start = 'J[expr floor([set latest_start($task_item)])]',
latest_finish = 'J[expr floor([set latest_finish($task_item)])]'
where
task_revision_id = (select live_revision from cr_items where item_id = :task_item)