Project and Portfolio Management Practitioners Forum
cancel

URGENT - want to know tables involved to fetch project settings property

SOLVED
Go to solution
Highlighted
Shravan Kathuri
Honored Contributor.

URGENT - want to know tables involved to fetch project settings property

Hi,

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.

Thanks
Shravan.
4 REPLIES
Jason Nichols K
Acclaimed Contributor.

Re: URGENT - want to know tables involved to fetch project settings property

Shravan,

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.

Jason


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
Shravan Kathuri
Honored Contributor.

Re: URGENT - want to know tables involved to fetch project settings property

Hi Jason,

Thanks for your response. If we select "Do not Allow" option, what would be the data in the Value column of itg_settings_attributes.

Thanks
Shravan.
Jason Nichols K
Acclaimed Contributor.
Solution

Re: URGENT - want to know tables involved to fetch project settings property

Do Not Allow = 'never'
Anytime = 'always'
Time periods = 'timePeriods'
Days = 'days'
Shravan Kathuri
Honored Contributor.

Re: URGENT - want to know tables involved to fetch project settings property

Hi Jason,

Perfect. Thanks for your response. Appreciate it.

Thanks
Shravan.