Hello team I was trying to transform Problems into CS Task and in the process of that I was copying the work notes and comments.
Script to copy comments and work notes:
/**
* MIBE
* This function will copy all comments and work notes from the a source record to the target record.
* @Param {GlideRecord} targetRecord 'any servicenow table' // the targetRecord record
* @Param {String} source_record_id // the sys_id of the source record
* @returns {String} answer 'the number of comments and work notes copied from the problem'
* usage: javascript:var util = new global.myTransformUtils(); util.copyCommentsAndNotesFromSource(current, current.source_record_id);
*/
copyCommentsAndNotesFromSource: function( /**GlideRecord */ targetRecord, /**string */ source_record_id) {
var answer = 0;
var query = "element_id=" + source_record_id;
var grSJF = new GlideRecord('sys_journal_field');
var isValideQuery = grSJF.isValidEncodedQuery(query);
if (isValideQuery) {
grSJF.addEncodedQuery(query);
grSJF.orderBy('sys_created_on');
//grSJF.setLimit(100);
grSJF.query();
while (grSJF.next()) {
var element = grSJF.getValue('element');
var element_id = grSJF.getValue('element_id');
var value = grSJF.getValue('value');
var sys_created_on = grSJF.getValue('sys_created_on');
var sys_created_by = grSJF.getValue('sys_created_by');
value = gs.getMessage("Created On") + " " + sys_created_on + "\n\r\n" + value;
if (element == 'work_notes') {
targetRecord.work_notes.setJournalEntry(value, sys_created_by);
}
if (element == 'comments') {
targetRecord.comments.setJournalEntry(value, sys_created_by);
}
answer++
targetRecord.update();
}
} else {
gs.info("Invalide query '" + query + "' reported in method copyCommentsAndNotesFromSource() the returned value will be 0");
}
return answer;
}
Script to transform 'problem' record to a 'sn_customerservice_task' record
/**
* MIBE
* This function will create the target record for the current problem.
* @Param {GlideRecord} problem 'problem' // the problem record
* @Param {String} targetTable // the target table in which we will copy the problem.
* @Param {Array} matchingFields // the fields to copy from the problem record to the target record
* @Param {String} csvData // the string containing csvData
* @returns {object} answer {record,cvv} record:'the generated record from problem' csv:'the generated csv data from the problem record'
* usage: javascript:var util = new global.mytransformUtils(); util.copyPRBToTargetRecord(current,"sn_customerservice_task",["sys_created_by","sys_created_on"]);
*/
copyPRBToTargetRecord: function( /**GlideRecord */ problem, /**String */ targetTable, /**Array */ matchingFields, /**String */ csvData) {
var answer = null;
var targetRecord = new GlideRecord(targetTable);
targetRecord.initialize();
targetRecord.autoSysFields(false);
for (var i = 0; i < matchingFields.length; i++) {
var field = matchingFields[i];
var value = problem.getValue(field);
if (field == 'state') {
value = this.generateState(problem,targetTable);
}
if (field == 'impact') {
value = this.generateImpact(problem);
}
if (field == 'urgency') {
value = this.generateUrgency(problem);
}
targetRecord.setValue(field, value);
}
//if(targetTable == 'sn_customerservice_task'){
targetRecord.setValue('correlation_id',problem.getValue('number'));
//}
targetRecord.setValue('u_created_from_problem', problem.getValue('sys_id')); // to keep the track after the transformation.
targetRecord.insert();
answer = {};
if (csvData) {
csvData = this.addToCSVData(targetRecord, csvData);
}
answer.csv = csvData;
answer.record = targetRecord;
targetRecord.autoSysFields(true);
return answer;
}
after the generation of new 'sn_customerservice_task' records I've observed the following display in the activity stream:
but right after I try to add a new work note it shows:
Any idea on why this is happening? and how can I fix it?
1 ACCEPTED SOLUTION
