URGENT - want to know tables involved to fetch project settings property
We are using PPM 7.5. We want to know the tables involved to fetch the project settings property ( "After a task is complete, allow time to be logged:" under time management section of Cost And Effort). Can anyone please help me. It is little bit urgent.
Re: URGENT - want to know tables involved to fetch project settings property
Here is a select statement that will get you the value you are looking for. There is a bind variable at the end for the Request_ID of the Project. Below this statement is another select statement that will get you a list of all of the possible key maps.
SELECT isa.value FROM kcrt_fg_pfm_project fg , pm_project_types pt , itg_settings_attributes isa , itg_settings_cont_attrs isca WHERE fg.prj_project_id = pt.project_id AND isca.settings_container_id = pt.pt_settings_key AND isa.settings_attribute_id = isca.settings_attribute_id AND isca.attr_map_key = 'CE.timeAfterTaskClosure' AND fg.request_id = :Project_Request_ID;
select distinct isca.attr_map_key from itg_settings_cont_attrs isca order by 1