Setting true/false flag for field using business rule

[Mrman]

Hi All,

Can someone please help with the below Business rule .When checking the logs it shows as rows retrieved: 0 . Please guide.

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

  var sci = current.u_sourceci;

  var rel = new GlideRecord('u_maximo_cmdb_ci');

  rel.addQuery('u_cinum', sci);

  rel.addQuery('u_hierarchypath', 'OPERATING SYSTEM \ AIX');

  rel.addQuery('u_cmdb_class_name', 'u_cmdb_ci_logical_partition');

  rel.query();

  gs.log("rows retrieved :"+rel.getRowCount());

  if(rel.next()){

  gs.log("HELLO IF");

  current.u_aixlpar = 'True';

  }

})(current, previous);

[Chuck Tomasi]

Just as a test... can you tell me what you get when you right click on the breadcrumb shown below and choose Copy Query? Paste the result here... I suspect it may be a "value" vs. "label" thing

[Mrman]

Hi Chuck,

Please see the result below when I did Copy Query .

u_hierarchypath=OPERATING SYSTEM \ AIX^u_cmdb_class_name=u_cmdb_ci_logical_partition

[Chuck Tomasi · Accepted solution]

Found it! It's definitely the backslash. It's a special character in Javascript that says 'the next character goes with this like \n, \t, etc.' To get it to work, change your query to use double backslash. That tells Javascript that the next character is a backslash, not a special character;

u_hierarchypath=OPERATING SYSTEM \\ AIX^u_cmdb_class_name=u_cmdb_ci_logical_partition

Sorry, I should have seen this earlier. It's been a crazy week.

[Mrman]

This Worked great Chuck. Thanks.