Our vBulletin migration is complete.
Welcome vBulletin users! All content and user information from the Micro Focus Forums (vBulletin) site has been migrated to this site. READ MORE.
Shravan Kathuri Absent Member.
Absent Member.
91 views

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

Jump to solution
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.
0 Likes
1 Solution

Accepted Solutions
Jason Nichols K Absent Member.
Absent Member.

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

Jump to solution
Do Not Allow = 'never'
Anytime = 'always'
Time periods = 'timePeriods'
Days = 'days'
4 Replies
Jason Nichols K Absent Member.
Absent Member.

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

Jump to solution
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
0 Likes
Shravan Kathuri Absent Member.
Absent Member.

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

Jump to solution
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.
0 Likes
Jason Nichols K Absent Member.
Absent Member.

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

Jump to solution
Do Not Allow = 'never'
Anytime = 'always'
Time periods = 'timePeriods'
Days = 'days'
Highlighted
Shravan Kathuri Absent Member.
Absent Member.

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

Jump to solution
Hi Jason,

Perfect. Thanks for your response. Appreciate it.

Thanks
Shravan.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.