Setting the value for Location in cmdb_ci

[Mrman]

Hi All,

Can someone please help with the below Transform script . I am trying to set the Location (location) field in cmdb_ci which is target table in Transform script.

The script is working fine when I checked in Logs , and also background script .When I checked the logs it returns the display value of name , please see below screenshot.

When I check it Location field in cmdb_ci after Transform, it is blank. not showing any value.

Transform Script:

==============

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

  var sloc = source.u_cilocation.toString();

  var loc = new GlideRecord('cmn_location');

  loc.addQuery('u_description',sloc);

  loc.query();

  gs.log("Location: "+loc.getEncodedQuery());

  if(loc.next()){

  gs.log("IF STATEMENT");

  //var dnm = loc.getDisplayValue('name');

  //target.location = loc.getDisplayValue('name');

  target.location = loc.name;

      gs.log("TagetLOC :"+target.location);

  }

})(source, map, log, target);

Log screenshot:

=============

[Mrman]

Ok Srivastava. I tried that initally , it did not work . value was not getting set with that .

Please let me know if I can mark your answer as correct .

[Ramakrishna Kat · Accepted solution]

Hi Ravishankar,

Please find below code. this is help full for you.

var emp = source.u_cilocation;

  var gr = new GlideRecord("table name");

  gr.addQuery("location field name", emp);

  gr.query();

  if (gr.next()) {

  var reqRecord = current..getRefRecord();

  reqRecord.target.location = gr.sys_id;

  }