Scripting when dot-walking two levels

[keesh]

Hi All,

I'm working on a catalog item that includes 2 variables: Computer (references [cmdb_ci_computer] table) & Stockroom (references [alm_stockroom] table). The requirement is to automatically populate the Stockroom variable based on the CI selected in the Computer variable. This requires 2 levels of dot-walking from the CI.Asset.Stockroom and I believe the best approach is to create a Script Includes + Catalog Client Script. I created both scripts below, however the functionality isn't working. Any guidance on what's missing would be much appreciated.

Computer CI Record:

Hardware Asset Record:

// Script Includes

var ComputerUtils = Class.create();

ComputerUtils.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    getCIDetails: function(){

      var id = this.getParameter('sysparm_computer');

      var gr = new GlideRecord('cmdb_ci_computer');

      gr.get(id);

      return gr.asset.stockroom.getDisplayValue(); 

    },

    type: 'ComputerUtils'

});

// Catalog Client Script

function onChange(control, oldValue, newValue, isLoading, isTemplate) {

    if (isLoading || newValue === '') {

        return;

    }

    var ga = new GlideAjax('ComputerUtils');

    ga.addParam('sysparm_name', 'getCIDetails');

    ga.addParam('sysparm_computer',g_form.getValue('computer'));

    ga.getXML(callBackMethod);

}

function callBackMethod(response) {

    var answer = response.responseXML.documentElement.getAttribute("answer");

    if(answer != ''){

        g_form.setValue('stockroom', answer); 

    }

}

[Trung]

hi @keesh 

var grAsset = current.asset.getRefRecord();
if(grAsset.isValidRecord()) { // << only perform operations on it if it's a valid record
    return grAsset.getDisplayValue("stockroom"); 
}
return "";

please replace my code for line "return gr.asset.stockroom.getDisplayValue();"

[keesh]

Hi - Thanks for the response. Unfortunately that script didn't work.

[burbigo1]

Hey, I really can't see what can be missing.

SHAREit MX Player

[keesh]

Any input from the community would be appreciated.