Name

sn_gf.GoalImportUtil

Description

No description available

Script

var GoalImportUtil = Class.create();

GoalImportUtil.createGR = function(obj, fieldMap) {
  var newGr = new GlideRecord(obj);
  newGr.initialize();
  for (var key in fieldMap)
      newGr.setValue(key, fieldMap[key]);
  newGr.insert();
  return newGr.sys_id;
};

GoalImportUtil.querySingleGR = function(obj, fieldMap) {
  var gr = new GlideRecord(obj);
  for (var key in fieldMap)
      gr.addQuery(key, fieldMap[key]);
  gr.query();
  return gr.next() ? gr.sys_id : false;
};

GoalImportUtil.getCoalesceFields = function(mapSysId) {
  var coalesceFields = {};
  var tEntriesGr = new GlideRecord('sys_transform_entry');
  tEntriesGr.addQuery('map.sys_id', mapSysId);
  tEntriesGr.addQuery('coalesce', '1');
  tEntriesGr.query();
  while (tEntriesGr.next())
      coalesceFields[tEntriesGr.getValue('target_field')] = tEntriesGr.getValue('source_field').replace('u_', '');
  return !global.JSUtil.isEmpty(coalesceFields) ? coalesceFields : {};
};

GoalImportUtil.getAssignedEntityType = function(sheetAssignedEntityType) {
  var tableName = "";
  var assignedEntityTypeResult = "";

  var dbo = new GlideRecord('sys_db_object');
  dbo.addEncodedQuery("label=" + sheetAssignedEntityType + "^ORname=" + sheetAssignedEntityType);
  dbo.query();
  if (dbo.next())
      tableName = dbo.name;

  if (tableName) {
      var assignedEntityConfig = new GlideRecord(GoalFrameworkConstants.GOAL_ASSIGNED_ENTITY_CONFIG_TABLE);
      assignedEntityConfig.addEncodedQuery("assigned_entity_table=" + tableName);
      assignedEntityConfig.query();
      if (assignedEntityConfig.next()) assignedEntityTypeResult = assignedEntityConfig.assigned_entity_table;
  }
  return assignedEntityTypeResult;
};

Sys ID

07eeca2f67b4d110b604d10c48f922d7

Offical Documentation

Official Docs: