postgresql7.3 SELECT live_revision FROM cr_items WHERE item_id = :project_item_id SELECT i.item_id FROM cr_items i, cr_revisions r WHERE i.item_id = r.item_id and r.revision_id = :project_id select status_id from pm_project_status where status_type = 'o' limit 1 select status_id from pm_project_status where status_type = 'c' limit 1 select pm_project__new_project_item ( :project_name, :project_code, :parent_id, :goal, :description, :mime_type, to_timestamp(:planned_start_date,'YYYY MM DD HH24 MI SS'), to_timestamp(:planned_end_date,'YYYY MM DD HH24 MI SS'), null, null, :ongoing_p, :status_id, :organization_id, :dform, current_timestamp, :creation_user, :creation_ip, :package_id ); SELECT i.item_id, i.content_type FROM cr_items i, pm_tasks_active t WHERE i.item_id = t.task_id and i.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, pm_tasks_active a where i.item_id = a.task_id and t.item_id in ([join $task_list ", "]) and i.live_revision = t.revision_id SELECT case when t.actual_hours_worked is null then 0 else t.actual_hours_worked end as worked, t.estimated_hours_work as to_work, t.item_id as my_iid, to_char(to_date(to_char(end_date,'YYYY-MM-DD HH24:MI'),'YYYY-MM-DD HH24:MI'),'J') as task_deadline_j, to_char(to_date(earliest_start,'YYYY-MM-DD HH24:MI'),'J') as old_earliest_start_j, to_char(earliest_finish,'J') as old_earliest_finish_j, to_char(latest_start,'J') as old_latest_start_j, to_char(latest_finish,'J') as old_latest_finish_j, t.percent_complete as my_percent_complete, s.status_type from pm_tasks_revisionsx t, cr_items i, pm_tasks_active ti, pm_task_status s where t.item_id in ([join $task_list ", "]) and i.live_revision = t.revision_id and i.item_id = ti.task_id and ti.status = s.status_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, ongoing_p 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 = :max_earliest_finish, latest_finish_date = :min_latest_start where project_id = (select live_revision from cr_items where item_id = :project_item_id) select i.parent_id from cr_items i, cr_items ip, pm_projects p, pm_projects pp where i.item_id = :project_id and ip.item_id = i.parent_id and p.project_id = i.latest_revision and pp.project_id = ip.latest_revision select parent_id from cr_items where item_id = :my_item_id select pm_project__get_root_folder (:package_id, 'f') select pm_project__get_root_folder (:package_id, 'f') update pm_tasks_revisions set earliest_start = :es, earliest_finish = :ef, latest_start = :ls, latest_finish = :lf where task_revision_id = (select live_revision from cr_items where item_id = :task_item) SELECT case when o.name is null then p.title else p.title || ' (' || o.name || ')' end, p.item_id FROM pm_projectsx p LEFT JOIN organizations o ON p.customer_id = o.organization_id, cr_items i, pm_project_status s WHERE p.project_id = i.live_revision and s.status_id = p.status_id and $extra_query s.status_type = 'o' ORDER BY lower(p.title), lower(o.name) select s.description from cr_items i, pm_projects p, pm_project_status s where i.item_id = :project_item_id and p.project_id = i.latest_revision and s.status_id = p.status_id SELECT party_id FROM pm_project_assignment WHERE project_id = :project_item_id and party_id = :party_id LIMIT 1 SELECT party_id, role_id FROM pm_project_assignment a WHERE project_id = :project_item_id SELECT i.item_id, i.content_type FROM cr_items i, pm_tasks_active t WHERE i.item_id = t.task_id and i.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,'YYYY-MM-DD HH24:MI') as today from pm_tasks_revisionsx t, cr_items i, pm_tasks_active a where i.item_id = a.task_id and t.item_id in ([join $task_list ", "]) and i.live_revision = t.revision_id SELECT case when t.actual_hours_worked is null then 0 else t.actual_hours_worked end as worked, t.estimated_hours_work as to_work, t.item_id as my_iid, to_char(end_date,'YYYY-MM-DD HH24:MI') as task_deadline, to_char(earliest_start,'YYYY-MM-DD HH24:MI') as old_earliest_start, to_char(earliest_finish,'YYYY-MM-DD HH24::MI') as old_earliest_finish, to_char(latest_start,'YYYY-MM-DD HH24::MI') as old_latest_start, to_char(latest_finish,'YYYY-MM-DD HH24::MI') as old_latest_finish, t.percent_complete as my_percent_complete, s.status_type from pm_tasks_revisionsx t, cr_items i, pm_tasks_active ti, pm_task_status s where t.item_id in ([join $task_list ", "]) and i.live_revision = t.revision_id and i.item_id = ti.task_id and ti.status = s.status_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,'YYYY-MM-DD HH24:MI') as start_date, to_char(planned_end_date,'YYYY-MM-DD HH24:MI') as end_date, ongoing_p 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 = :max_earliest_finish, latest_finish_date = :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 = :es, earliest_finish = :ef, latest_start = :ls, latest_finish = :lf where task_revision_id = (select live_revision from cr_items where item_id = :task_item) select i.item_id as project_item_id from cr_items i, pm_projects p where p.project_id = i.latest_revision and i.parent_id in ([join $project_list ,]) select distinct p.item_id from pm_projectsx p, pm_projectsx p2 where p.parent_id = p2.item_id and p.parent_id = :parent select distinct status_id from pm_projectsx where item_id in ($projects) select i.item_id from cr_items i, cr_revisions r, pm_projects p where lower(r.title) like '%${keyword}%' and i.latest_revision = r.revision_id and r.revision_id = p.project_id order by r.title asc select item_id, o.package_id as object_package_id from cr_items i, acs_objects o, pm_projects p where lower(p.project_code) like '%${keyword}%' and i.latest_revision = o.object_id and o.object_id = p.project_id order by title asc