How to calculate the number of incidents caused by change on change form

[Snow909]

Hello All,

On incident form i have created a new field called "Number of incidents caused by change" which is an integer.

This filed should auto populate with the count of incident caused by change

1. New Field which gets the count of incidents 

2.incidents caused by change related list

3. Edit is the place where we can add incidents or remove incidents

The issue is created a business rule with the below code, it works only when new incidents are added, but when we remove the incidents  the count is not getting updated.

BR code: for testing purpose i was using the info message to show on the form:

NOTE: Both the business rules work and update when new incidents are added but when removed from edit count not getting updated.

Script1 : written on the change form

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

// Add your code here
var TaskInc = new GlideRecord('incident');
TaskInc.addQuery('caused_by', current.sys_id);
//TaskInc.addEncodedQuery('caused_by!=NULL');
TaskInc.query();
var count = TaskInc.getRowCount();
gs.addInfoMessage("Total incidents caused by change before if condition --" + TaskInc.getRowCount());
//alert("change happened");

if (TaskInc.next()) {
if (count > 0) {
gs.addInfoMessage("Total incidents is greater than zero --" + TaskInc.getRowCount());

// current.u_number_of_incidents_caused_by_change = TaskInc.getRowCount();
// current.update();
} else {
gs.addInfoMessage("total incident count is Zero");
// current.u_number_of_incidents_caused_by_change = 0;
// current.update();
//gs.addInfoMessage(test)
}
}

})(current, previous);

Script 2: written on the incident form

(function executeRule(current, previous /*null when async*/ ) {
var task = new GlideRecord('incident');
task.addQuery('caused_by', current.caused_by);
task.query();
//gs.addInfoMessage("Incident count was --" + task.getRowCount());

var Chg = new GlideRecord('change_request');
Chg.addQuery('sys_id', current.caused_by);
Chg.query();
if (Chg.next()) {
Chg.u_number_of_incidents_caused_by_change = task.getRowCount();
Chg.update();

}

})(current, previous);

[Hajar BENJAHHAR]

That what you want to obtain ? 

There is no incident caused by this change : 

There are incidents caused by the change : 

[Snow909]

That's the expected behavior and the screenshsots shared by you are correct. do i need to make any  changes on the code to work on my end.

Thanks Again

[Hajar BENJAHHAR]

No you shouldn't the code seems correct . 

[Snow909]

can you share the code in editable format , so that i can copy and add in personal instance and check it out. 

[Hajar BENJAHHAR]

function onLoad() {
    var ajax = new GlideAjax('NumberIncidentCausedByChange');
    ajax.addParam('sysparm_name', 'getNumberIncident');
    ajax.addParam('sysparm_sys_id_causedBy', g_form.getUniqueValue());
    ajax.getXML(displayNumberIncident);

    function displayNumberIncident(response) {
        var value = response.responseXML.documentElement.getAttribute('answer');
        g_form.setValue('u_number_incident', value);
    }


}

var NumberIncidentCausedByChange = Class.create();
NumberIncidentCausedByChange.prototype = Object.extendsObject(AbstractAjaxProcessor, {

	getNumberIncident: function(){
		var inc = new GlideRecord('incident');
		inc.addQuery('caused_by',this.getParameter('sysparm_sys_id_causedBy'));
		inc.query();
		return inc.getRowCount();
	},
    type: 'NumberIncidentCausedByChange'
});