When incident is resolved i need to update the Outage table with Outage type,Begin and End values

[Rajamouly]

Upon Incident Resolution, the assignee will fill out Actual Start/Actual End and Outage Record type fields on the incident form and these fields will be populated automatically on the Outage record.

For this i have created after business rule, and mentioned the condition

Condition:urrent.incident_state.changesTo (6)

Script: 

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

var outageGr = new GlideRecord('cmdb_ci_outage');
outageGr.setValue('begin', current.getValue('work_start'));
outageGr.setValue('end', current.getValue('work_end'));
outageGr.setValue('type', current.getValue('u_outage_record_type'));
outageGr.update();

})(current, previous);

Am i missing anything here, Please help me.

 

 

[Mike_R]

Is the Outage record already created at this point and related to the Incident, or are you attempting to create the Outage record through this business rule?

[Mike_R]

if the outage record is already created/associated, you can try this

var outageGr = new GlideRecord('cmdb_ci_outage');
outageGr.get('task_number', current.sys_id);
outageGr.setValue('begin', current.getValue('work_start'));
outageGr.setValue('end', current.getValue('work_end'));
outageGr.setValue('type', current.getValue('u_outage_record_type'));
outageGr.update();

If you are attempting to create the outage record, i would create a flow instead of a business rule.

[Rajamouly]

Hello Mike,

Thanks for response, Yes Outage is created automatically through business rule,i have tried the code below but no luck

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

var outageGr = new GlideRecord('cmdb_ci_outage');
outageGr.addQuery('task_number','current.sys_id');
outageGr.query();
if (outageGr.next()) {
outageGr.begin = current.work_start;
outageGr.end = current.work_end;
outageGr.type = current.u_outage_record_type;
outageGr.update();
}
})(current, previous);

[Mike_R]

Since you are trying to create a new record, try this

var outageGr = new GlideRecord('cmdb_ci_outage');
outageGr.initialize();
outageGr.setValue('task_number', current.sys_id);
outageGr.setValue('begin', current.getValue('work_start'));
outageGr.setValue('end', current.getValue('work_end'));
outageGr.setValue('type', current.getValue('u_outage_record_type'));
outageGr.insert();