Count Affected CIs on incident form

[Sagar_pawar]

Hello All,

can anyone please guide me how to count affected ci on incident form and display when form load?

Thank You.

[reshmapatil]

Hi @Sagar_pawar ,

Write a display business rule doing GlideAggregate on the affected ci table and display the message using gs.addInfoMessage().

Try below code:

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

// Add your code here
var count = 0;
var affCIGA = new GlideAggregate('task_ci');
affCIGA.addAggregate('COUNT');
affCIGA.addEncodedQuery('task.number='+current.getUniqueValue());
affCIGA.query();
while(affCIGA.next()){
count = affCIGA.getAggregate('COUNT');
}
gs.addInfoMessage('Affected CI Count:: '+count);

})(current, previous);

Regards,

Reshma

**Please mark my answer correct or helpful based on the impact**

[Saurav11 · Accepted solution]

Hello,

Please do the below:-

Write a display BR on incident table with the below code:-

(function executeRule(current, previous /*null when async*/) {
var rec = new GlideRecord('task_ci');
   rec.addQuery('task', current.sys_id); 
   rec.query();
   if(rec.next()){
     g_scratchpad.count=rec.getRowCount();
   
}
})(current, previous);

Then write a onload client script with below code:-

Now if you want to show it as a message on load use below:-

function onLoad() {
   //Type appropriate comment here, and begin script below
   var count=g_scratchpad.count;
	g_form.addInfoMessage(count);
}

Now if you want to set it on a field on load use below:-

function onLoad() {
   //Type appropriate comment here, and begin script below
   var count=g_scratchpad.count;
	g_form.setValue('fieldname',count);
}

Please mark my answer as correct based on Impact. 

[Sagar_pawar]

Hello @Saurav11, I want to show XYZ field once we added affected ci's in related list so can you please guide me how we can do this without onload client  i am trying to achieve the same.

[reshmapatil]

Hi @Sagar_pawar ,

Try it with Data Policy:

Regards,

Reshma

**Please mark my answer correct or helpful based on the impact**