Name

global.FixScriptUtils

Description

A collection of useful methods for writing fix scripts

Script

var FixScriptUtils = Class.create();
FixScriptUtils.prototype = {
  initialize: function() {
  },

  type: 'FixScriptUtils',
  
  updateSysDocumentation: function(tableName, columnName, lang, key, newValue, glideRecord) {
  	// The glideRecord object can be reused for multiple invocations. If it is not present, initialize it
  	if (!glideRecord)
  		glideRecord = new GlideRecord("sys_documentation");
  	
  	// Fail silently if the update request is insufficiently specified
  	if (gs.nil(tableName) || gs.nil(lang) || gs.nil(key) )
  		return glideRecord;
  	glideRecord.initialize();
  	glideRecord.addQuery("name", tableName);
  	glideRecord.addQuery("element", columnName);
  	glideRecord.addQuery("language", lang);
  	glideRecord.query();
  	if (glideRecord.next()) {
  		glideRecord.setValue(key, newValue);
  		// Update the record if setting the key/value pair above made the record dirty
  		if (glideRecord.changes() && glideRecord.update() != null) {
  			gs.log("Updated sys_dictionary attribute " + key + " for record " + 
  				   this.generateRecordReference(tableName, columnName));
  		}
  		else {
  			gs.log("sys_documentation attribute " + key + " for record " + 
  				   this.generateRecordReference(tableName, columnName) + " was up to date");
  		}
  	} else {
  		gs.log("sys_documentation attribute " + key + " for record " + 
  			   this.generateRecordReference(tableName, columnName) + " was not found");
  	}
  	return glideRecord;
  },
  
  generateRecordReference: function (tableName, columnName) {
  	if (gs.nil(tableName))
  		return "";
  	if (gs.nil(columnName))
  		return tableName;
  	return tableName + "." + columnName;
  }
};

Sys ID

e77e49b2d7320100600949d48e6103f8

Offical Documentation

Official Docs: