Hi All,
I am trying to fetch the value of task number(task_id) i.e. change number from Assessment Instance (asmt_assessment_instance) table as soon as a record is inserted using a BR
Please refer below screenshot for BR and table
BR is created After Insert
But every time record is getting inserted in assessment instance table, no task_id is getting returned in BR
Please suggest, how should I fetch task_id of the inserted record
From your BR name I am assuming that you want to count the number of assessments taken for a particular Change request.
Try the below BR-
On Assessment Instance table, every time an instance for "Change Risk Assessment" is set to Complete state-
Script will be-
var otherAssessmentCount = 0;
var checkIfOtherAssessment = new GlideAggregate(current.getTableName());
checkIfOtherAssessment.addEncodedQuery('metric_type='+current.metric_type.sys_id+'^task_id='+current.task_id.sys_id);
checkIfOtherAssessment.addAggregate('COUNT');
checkIfOtherAssessment.query();
if(checkIfOtherAssessment.next()){
otherAssessmentCount = checkIfOtherAssessment.getAggregate('COUNT');
}
var chg = new GlideRecord('change_request');
chg.get(current.task_id);
chg.u_total_assessments_taken = otherAssessmentCount; //Here add the name of your custom field on change_request
chg.update();
And the change request will be updated-
