question Re: Need to populate Planned start date and planned end date in change task from change request. in ITSM forum

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

Gouse — Sun, 23 May 2021 07:39:53 GMT

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

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

Shubham Tipnis — Sun, 23 May 2021 07:50:29 GMT

Hi Gouse,

You could try below BR.

(function executeRule(current, previous /*null when async*/) {
	
	var parentChange = current.change_request.getRefRecord();
	
	if (parentChange.isValidRecord()) {
		current.planned_start_date = parentChange.start_date;
		current.planned_end_date = parentChange.end_date;
	}


})(current, previous);

Please mark correct/helpful if applicable.

Regards,

Shubham

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

Gouse — Sun, 23 May 2021 08:02:47 GMT

Hi shubham,

thanks for your replay. I have try this BR but should not populated.

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

Shubham Tipnis — Sun, 23 May 2021 08:27:10 GMT

Hi Gouse,

Check if the fields are populated with the dates after you save/submit the record. Those fields won't be populated until you click submit. The previous code works as display business rule.

Regards,

Shubham

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

DirkRedeker — Sun, 23 May 2021 09:24:52 GMT

Maybe @Shubham Tipnis should mention, that the Busines Rule should be created on the "CHANGE TASK" table and NOT on the "CHANGE Request" Table.

The Business Rule, that he mentioned will copy the Start and End Date on every NEW or CHANGED "Change Task" as it is touched.

But if you want to "write down" the "Start" and "End" Date also to all EXISTING Change Tasks as soon as you change the "Change Request", you need to add an additional Business Rule on the "Change Request" table as well.

THAT BR should loop through all "Change Tasks" related to the "Change Request" and update each record.

Does that make sense to your question?

Does that match what you are trying to achieve?

Let me know if that answers your question and mark my answer as correct and helpful.

BR
Dirk

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

Aman Singh_ — Mon, 24 May 2021 05:41:29 GMT

Hi,

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

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

Aman

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

Ankur Bawiskar — Mon, 24 May 2021 06:01:56 GMT

@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);

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

Regards
Ankur

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

Gouse — Mon, 24 May 2021 13:35:02 GMT

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();
}

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

Gouse — Mon, 24 May 2021 13:36:48 GMT

Thanks for your replay.

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

Ankur Bawiskar — Mon, 24 May 2021 13:37:36 GMT

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

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

Gouse — Mon, 24 May 2021 13:51:59 GMT

yes i got your point and try our code its working

thanks