Name
sn_lookup_verify.LookupVerifyGenUtil
Description
No description available
Script
var LookupVerifyGenUtil = Class.create();
LookupVerifyGenUtil.prototype = {
initialize: function() {
},
associateRecordToInteraction: function(term, interactionId) {
// check if the string for lookup is a record number
var gr = sn_lv.LookupVerifyUtil.getNumberRecord(term);
if (gr == null) {
return null;
}
var tableName = gr.getTableName();
var sysId = gr.getValue('sys_id');
var tableInfo = {"table" : tableName, "sysId" : sysId};
var tableHierarchy = new GlideTableHierarchy(tableName);
if (tableHierarchy.getTables().indexOf("task") > -1) {
var existingRelationship = new GlideRecord("interaction_related_record");
existingRelationship.addQuery("interaction", interactionId);
existingRelationship.addQuery("document_id", sysId);
existingRelationship.setLimit(1);
existingRelationship.query();
if (!existingRelationship.next()) {
// add the related record to interaction
var gr = new GlideRecord('interaction_related_record');
gr.initialize();
gr.document_id = tableInfo.sysId;
gr.document_table = "task";
gr.interaction = interactionId;
gr.task = tableInfo.sysId;
gr.type = "task";
gr.insert();
}
}
return JSON.stringify(tableInfo);
},
type: 'LookupVerifyGenUtil'
};
Sys ID
123fd398534310102c30ddeeff7b12cc