Name

sn_itom_license.ExcludeMetadataAjax

Description

Utiliy for Exclude Licensing Medatdata

Script

var ExcludeMetadataAjax = Class.create();
ExcludeMetadataAjax.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {

  getTableNames : function(tableName) {
  	var tableUtil = new global.UtilScript();
  	var tableArr =  tableUtil.getTables(tableName);
  	return tableArr;
  },

  getCategory : function() {
  	var tableName = this.getParameter("sysparm_table_name");
  	var tableArr = this.getTableNames(tableName);
  	var categories = [];
  	tableArr.forEach(function(name) {
  		var flag = true;
  		var gr = new GlideRecord('itom_lu_metadata');
  		gr.addQuery('table',name);
  		gr.query();
  		if(gr.canRead() && gr.getRowCount() > 0) {
  			while(gr.next() && flag && categories.indexOf(gr.getValue('category')) == -1)
  				categories.push(gr.getValue('category'));

  			if(categories.length)
  			flag = false;
  		}
  	});
  	return JSON.stringify(categories);
  },

  getParentTable : function() {
  	var tableName = this.getParameter("sysparm_table_name");
  	var category = this.getParameter("sysparm_category");
  	var tableArr = this.getTableNames(tableName);
  	var res = '';
  	tableArr.forEach(function(name) {
  		var gr = new GlideRecord('itom_lu_metadata');
  		gr.addQuery('table',name);
  		gr.addQuery('category',category);
  		gr.query();

  		if(gr.canRead() && gr.getRowCount() > 0)
  			res = name;
  	});
  	return res;
  },

  getCategoriesForSKUType: function() {
      var skuTypes = this.getParameter("sysparm_skuType");
      var skuTypeList = skuTypes.split(',');
      var categoryList = [];
      skuTypeList.forEach(function(sku) {
          var gr = new GlideRecord('itom_lu_category_metadata');
          gr.addQuery('sku_type', sku);
          gr.query();
          while (gr.canRead() && gr.next()) {
              if (categoryList.indexOf(gr.getValue('category')) == -1)
                  categoryList.push(gr.getValue('category'));
          }
      });
      return JSON.stringify(categoryList);
  },


  type: 'ExcludeMetadataAjax'
});

Sys ID

1ef37136c7471010b92c660703c26014

Offical Documentation

Official Docs: