Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Change the view type for planned start date in project request type

Highlighted
Pachi
Collector

Change the view type for planned start date in project request type

Hi,

 

Would it possible to
change the 'Planned Start Period' and 'Planned End Period' in the
project creation space in PPM to a calendar type option, similar to that of the
enclosed below. 

 

Please advice, as i see query right now which is present for this and a token KNTA_PLAN_START_DATE

 

SELECT   p2.period_id, p2.period_full_name
    FROM knta_periods p1, knta_periods p2              -- p1 is current period
   WHERE p2.period_type_id = 4
     AND p2.period_type_id = p1.period_type_id
     AND TRUNC (CURRENT_DATE, 'DDD') BETWEEN TRUNC (p1.start_date, 'DDD')
                                         AND TRUNC (p1.end_date, 'DDD')
     AND UPPER (p2.period_full_name) LIKE UPPER ('?%')
     AND (   p2.period_full_name LIKE UPPER (SUBSTR ('?', 1, 1)) || '%'
          OR p2.period_full_name LIKE LOWER (SUBSTR ('?', 1, 1)) || '%')
     [FILTER_FIELD_SQL]
 ORDER BY p2.start_date

Regards,
Pachi
6 REPLIES
Utkarsh_Mishra
Honored Contributor

Re: Change the view type for planned start date in project request type

It won't be a good option to change out of the box fields or validation.

Rather you can create a duplicate field with same name (Planned Start/end) and Date validation.
Then hide the out-of the box fields.
And then create a rule to poupulate out-of-the-box fields (plannned start/end) values based on the duplicate fileds.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Pachi
Collector

Re: Change the view type for planned start date in project request type

If i go with the duplicates, will there any places tht i need to map it as well,

Because i am not sure if this token which is being used , is used or dependent anywhere else, as i will have to disable this, as i will be going for the new one.

Regards,
Pachi
Utkarsh_Mishra
Honored Contributor

Re: Change the view type for planned start date in project request type

Don't disable the out-of-the box fields; just set disaply=no

 

Secondly popoulate these ootb fields with the new dupliate fileds values (on field change rule). Also create a rule to change duplaicte fields value based on ootb field (as these ootb fields can be set via commands or other updates).

 

 

Doing do will not impact any existing implementation.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Pachi
Collector

Re: Change the view type for planned start date in project request type

I am not able to disable or edit this, Could you please advise.

 

Enclosed is the screen shot.

Regards,
Pachi
penoles
Regular Collector

Re: Change the view type for planned start date in project request type

You should not disable these 2 fields for a project as they are mandatory  required for creating a project.

What benefits can you get from  setting a exact date for  project's plan start  date? Moreover you can set a exact  date for project actual start date.

 

Mohit_Agrawal
Frequent Visitor

Re: Change the view type for planned start date in project request type

Hi Prachi,

 

You cannot disable the out of the box fields. Rather do what Utkarsh has suggseted.

What you can do is, Just set Display as No (according to attached pic).

 

Then create two fields as Planned Start and End date, with DATE validation (As shown in attached pic).

 

Then create a SQL rules that will copy the value selected in the new fields to the old fields. So that all the places where you have passed the token for start and end dates will work without any issue..

 

 

PS: If the post resolves your issue, please give KUDOS and mark it as Accepted Solution.

 

Thanks!!

Mohit Agrawal

 

//Add this to "OnDomLoad" event