Dzorzi
New Member.
323 views

Project settings - change scheduled effort

Jump to solution

Good morning

I want change to "manually enter Scheduled Effort" in project settings for all existing project.

Now for do this I open each project and set manually the flag.

Is possible set that flag in one step for all projects?  For examble by modify a field in data Model?

 

Thanks

0 Likes
1 Solution

Accepted Solutions
Derek Giedd Honored Contributor.
Honored Contributor.

Re: Project settings - change scheduled effort

Jump to solution

If you are referring to the Project Settings, Cost and Effort tab, Scheduled Effort inthe Workplan section, Manually enter Scheduled Effort per task assignment radion button, then this should do it for you.  This also changes the Project Type to the same value.  If you want to leave the project type alone, then you will need to make a small change by adding the line "AND pt.project_id is null" in the WHERE clause.

UPDATE itg_settings_attributes
   SET VALUE = 'false',
       last_update_date = SYSDATE,
       last_updated_by = 1
 WHERE settings_attribute_id IN (
SELECT sca.settings_attribute_id
  FROM itg_settings_cont_attrs sca, itg_settings_attributes sa, pm_project_types pt
 WHERE sa.settings_attribute_id = sca.settings_attribute_id 
   AND sca.settings_container_id = pt.pt_settings_key
   AND sa.name = 'field.autoMode'
   AND pt.project_type_name LIKE 'Project');

You will need to change the last line to the project type affected by the change.  Or, if you wanit it for all project types, you can remove the last line except for ");".

 

-- Remember to give Kudos to answers! (click the KUDOS star)
0 Likes
2 Replies
Derek Giedd Honored Contributor.
Honored Contributor.

Re: Project settings - change scheduled effort

Jump to solution

If you are referring to the Project Settings, Cost and Effort tab, Scheduled Effort inthe Workplan section, Manually enter Scheduled Effort per task assignment radion button, then this should do it for you.  This also changes the Project Type to the same value.  If you want to leave the project type alone, then you will need to make a small change by adding the line "AND pt.project_id is null" in the WHERE clause.

UPDATE itg_settings_attributes
   SET VALUE = 'false',
       last_update_date = SYSDATE,
       last_updated_by = 1
 WHERE settings_attribute_id IN (
SELECT sca.settings_attribute_id
  FROM itg_settings_cont_attrs sca, itg_settings_attributes sa, pm_project_types pt
 WHERE sa.settings_attribute_id = sca.settings_attribute_id 
   AND sca.settings_container_id = pt.pt_settings_key
   AND sa.name = 'field.autoMode'
   AND pt.project_type_name LIKE 'Project');

You will need to change the last line to the project type affected by the change.  Or, if you wanit it for all project types, you can remove the last line except for ");".

 

-- Remember to give Kudos to answers! (click the KUDOS star)
0 Likes
Dzorzi
New Member.

Re: Project settings - change scheduled effort

Jump to solution

Thank you very much, it's the correct solution

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.