Name

global.PPMTableCheck

Description

Table Checker Utility

Script

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

  type: 'PPMTableCheck'
};

PPMTableCheck.isPortfolio = function (table) {
  PPMDebug.log('PPMTableCheck.isPortfolio: ' + table);
  var res = false;
  var record = new GlideRecord(table);
  res = record.instanceOf("pm_portfolio");
  return res;
};

PPMTableCheck.isProgram = function (table) {
  PPMDebug.log('PPMTableCheck.isProgram: ' + table);
  var res = false;
  var record = new GlideRecord(table);
  res = record.instanceOf("pm_program");
  return res;
};

PPMTableCheck.isProgramTask = function (table) {
  PPMDebug.log('PPMTableCheck.isProgramTask: ' + table);
  var res = false;
  var record = new GlideRecord(table);
  res = record.instanceOf("pm_program_task");
  return res;
};

//Returns true if table is instnaceOf release or product
PPMTableCheck.isRelease = function (table) {
  PPMDebug.log('PPMTableCheck.isRelease: ' + table);
  var res = false;
  var record = new GlideRecord(table);
  res = record.instanceOf("rm_release") || record.instanceOf("rm_product");
  return res;
  
};

PPMTableCheck.isProject = function (table) {
  PPMDebug.log('PPMTableCheck.isProject: ' + table);
  var res = false;
  var record = new GlideRecord(table);
  res = record.instanceOf("pm_project");
  return res;
};

PPMTableCheck.isProjectTask = function (table) {
  PPMDebug.log('PPMTableCheck.isProjectTask: ' + table);
  var res = false;
  var record = new GlideRecord(table);
  res = record.instanceOf("pm_project_task");
  return res;
};

PPMTableCheck.isDemand = function (table) {
  PPMDebug.log('PPMTableCheck.isDemand: ' + table);
  var res = false;
  var record = new GlideRecord(table);
  res = record.instanceOf("dmn_demand");
  return res;
};

PPMTableCheck.isPlannedTask = function (table) {
  var plannedTaskExtensions = GlideDBObjectManager.get().getAllExtensions('planned_task');
  PPMDebug.log('PPMTableCheck.isPlannedTask: ' + table + " -> " + plannedTaskExtensions.contains(table));
  return plannedTaskExtensions.contains(table);
};

Sys ID

6a8717349f413200598a5bb0657fcf4d

Offical Documentation

Official Docs: