Need to populate Planned start date and planned end date in change task from change request.

[Gouse]

Hi All,

After creating the change request with planned start date and planned end date fields. Automatically populate these dates in all change tasks.

Thanks in advance

[Aman Singh_]

Hi,

You can as well try the following in the default value:

Mark ✅ Correct/helpful, if applicable, Thanks!!

Aman

[Gouse]

Thanks for your replay.

[Ankur Bawiskar · Accepted solution]

@Gouse 

Are you saying you want those fields to be auto-populated when change_task is created?

if yes then you can use before insert BR on change_task and set the fields

(function executeRule(current, previous /*null when async*/) {

	// Add your code here
	current.start_date = current.change_request.start_date;
	current.end_date = current.change_request.end_date;

})(current, previous);

OR

You can also use flow designer to set the fields with no script

Regards
Ankur

[Gouse]

Thanks Ankur for your replay.

it is working fine with my below script 

Async insert BR on change request table 

var ch_task = new GlideRecord('change_task');
ch_task.addQuery('change_request',current.sys_id);

ch_task.query();
while(ch_task.next()){
ch_task.planned_start_date = current.start_date;
ch_task.planned_end_date = current.end_date;
ch_task.update();
}

[Ankur Bawiskar]

Hi,

your BR is async insert on change request.

What if there are no change tasks for that CHG?

by default CHG Task will be created post CHG Request; so not sure how the change tasks would be present as soon as CHG is created

Regards
Ankur