How to get value of field from GlideQuery

[Mrman]

Hi All,

Can Someone please help me on this Business rule I am working .I am creating a after business rule on a custom table called u_test_cmdb_ci   and this runs when inserted or updated.

I want a field from another custom table called u_met_integration_maps . Please see the below code and suggest me the changes I need to do . I am getting result as undefined.

Log: METValue undefined

Code:

======

(function executeRule(current, previous /*null when async*/) {

var hierarchypath = current.u_hierarchypath;
var Max = new GlideRecord('u_met_integration_maps');
Max.addQuery('u_module','CMDBCI');
Max.addQuery('u_direction','Inbound [ System > MET ]');
Max.addQuery('u_mapped_sys_value', hierarchypath);
Max.query();
   
var r = Max.u_met_value;
    gs.log("METValue "+r);
  current.u_cmdb_class_name = r;
  current.update();

})(current, previous);

[Chuck Tomasi]

The BR is only going to update the current record (the way you have it.)

If you want to update the other three records, you'll need to write a BR to update those records.

BTW, you should never use a current.update() in a before or after BR.

Reference:

Business Rules Best Practices - ServiceNow Wiki  

[Mrman]

Hi Chuck,

Please guide me or provide any sample script for setting value for 3 records in the table which I am running the BR which have same hierarchypath.

Regards,

Ravishankar G

[Chuck Tomasi]

Sorry for the delay. I was OOO a lot last week for customer and personal.

The basic idea is that you need to get the records from the table and then update them accordingly.

Standard disclaimer: The following code is untested, requires review and potential modifications.

      var rec = new GlideRecord('YOURTABLEHERE');  

      rec.addQuery('field', 'value'); // only get records where field=value

      rec.query();  

        // loop through the records

      while (rec.next()) {  

            // Do something like set active=false like this. rec.active = false;

            rec.update();  

      }

[Mrman]

Hi Chuck,

Could you please guide me or provide sample code on business rule for setting value for 3 records in table on which I am running BR.

Also , please suggest an alternate without using current.update();

Regards,

Ravi G