Hi all,
I created the below script for Change task for Attachment Mandatory and but
IN THE emergency change short descrption is impementation task , in code i wrote implementation
(function executeRule(current, previous /*null when async*/ ) {
var chg = new GlideRecord("change_request");
chg.addQuery('sys_id',current.change_request);
chg.query();
if(chg.next())
{
gs.log('type'+chg.type);
var change_type= chg.type;
}
if (((current.short_description == "Post implementation testing") && (change_type == 'normal' || change_type == 'standard')) || (current.short_description == 'implementation' && (change_type == 'emergency'))) {
var attachmentGR = new GlideAggregate('sys_attachment');
attachmentGR.addAggregate('COUNT');
attachmentGR.addQuery('table_name', 'change_task'); // Change Task table
attachmentGR.addQuery('table_sys_id',current.sys_id); // Current Change Task record
attachmentGR.query();
if (attachmentGR.next()) {
var attachcount = attachmentGR.getAggregate('COUNT');
}
}
if(attachcount == 0)
{
gs.addErrorMessage('The attachment of the sanity implementation test result is mandatory before closing the post-implementation testing CTASK');
current.setAbortAction(true);
current.state = previous.state;
current.setRedirectURL(current);
}
})(current, previous);
any one can help on this code
