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

Offical Documentation

Official Docs: