Hi All,
I have two tables, Exception and Service Request. I have written a Business Rules that update the exception id and exception status in the incident table. Basis on the reference number.
This BR works only when I have exception created first and Service Request created next for the same reference number/SR ID. But It does not work when it is vice versa. I want it to work on both the cases.
Below are the screenshot and scripts for your reference.
Service Request (Exception ID and Exception Status) gets auto update basis on BR
Exception Table (Reference Number is looked in this table) if it is a match then it gets populated in the Service Request table.
Script
(function executeRule(current, previous /*null when async*/) {
var extracting = new GlideRecord('x_isgi_isg_governa_isg_pm_sla_exception');
extracting.addQuery('reference_number',current.sr_id);
extracting.addQuery('service_month',current.service_month);
extracting.query();
if(extracting.next()){
current.excep_id = extracting.sys_id;
current.excep_status = extracting.status;
}
//current.update();
})(current, previous);
Appreciate your input and early response.
Regards,
Narmi
