Hello Everyone
I have a requirement to pick only incident number from the updated work note of the sctask using email script.
Please suggest me on this. for your reference attached screenshot
2 ACCEPTED SOLUTIONS
@Vinod S Patil See if this helps you
This is working script which will help you to extract the incident number from the Work Notes. Kindly note that if you have customized the Incident Number formatting then regex needs to be altered accordingly. Below script will perfectly work for you in PDI as it is OOB.
var incGR = new GlideRecord('incident');
if (incGR.get('INC0010018')) {
var incidentSysId = incGR.getUniqueValue();
var journalGR = new GlideRecord('sys_journal_field');
journalGR.addQuery('element_id', incidentSysId);
journalGR.addQuery('element', 'work_notes');
journalGR.query();
var regex = /INC\d{7}/g;
var foundIncidents = [];
while (journalGR.next()) {
var note = journalGR.getValue('value');
var matches = note.match(regex);
if (matches) {
for (var i = 0; i < matches.length; i++) {
if (foundIncidents.indexOf(matches[i]) === -1) {
foundIncidents.push(matches[i]);
}
}
}
}
if (foundIncidents.length > 0) {
gs.print('Incident Numbers found in work notes of INC0010018:');
for (var j = 0; j < foundIncidents.length; j++) {
gs.print(foundIncidents[j]);
}
} else {
gs.print('No Incident Numbers found in work notes.');
}
} else {
gs.print('Incident INC0010018 not found.');
}
Outcome of the script would be something like this:
