postgresql7.1
select
item_id,
content_type
from
cr_items
where parent_id = :project_item_id
select
sum(p.actual_hours_completed) as projects_total_hours_worked
from
pm_projectsx p, cr_items i
where
p.item_id in ([join $project_list ", "]) and
i.live_revision = p.revision_id
select
sum(t.actual_hours_worked) as tasks_total_hours_worked
from
pm_tasks_revisionsx t, cr_items i
where
t.item_id in ([join $task_list ", "]) and
i.live_revision = t.revision_id
update
pm_projects
set
actual_hours_completed = :total_hours_worked
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')