HI @chrifan ,
I trust you are doing great.
Please find the below code
// Get the current Change Request record
var changeRequest = new GlideRecord('change_request');
if (changeRequest.get(current.change_request)) {
// Count Incidents linked to this Change Request
var incidentCount = new GlideAggregate('incident');
incidentCount.addQuery('related_to', current.change_request);
incidentCount.addAggregate('COUNT');
incidentCount.query();
if (incidentCount.next()) {
// Display the count on the Change Request form
current.incidents_linked = incidentCount.getAggregate('COUNT');
}
// Count Incidents triggered by this Change Request and marked as Failed
var failedIncidentCount = new GlideAggregate('incident');
failedIncidentCount.addQuery('triggered_by', current.change_request);
failedIncidentCount.addQuery('state', 'Failed'); // Assuming the state field indicates failure
failedIncidentCount.addAggregate('COUNT');
failedIncidentCount.query();
if (failedIncidentCount.next()) {
// Display the count on the Change Request form
current.failed_incidents = failedIncidentCount.getAggregate('COUNT');
}
}
Was this answer helpful?
Please consider marking it correct or helpful.
Your feedback helps us improve!
Thank you!
Regards,
Amit Gujrathi
