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);

[Mrman]

Hi Chuck,

I tried with below as you suggested, still it returned 0 records.

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

  var rel = new GlideRecord('u_maximo_cmdb_ci');

  rel.addEncodedQuery('u_hierarchypath=OPERATING SYSTEM \ AIX^u_cmdb_class_name=u_cmdb_ci_logical_partition');

  rel.query();

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

  gs.log("Result :"+rel.getEncodedQuery());

})(current, previous);

[Chuck Tomasi]

Thanks for your patience.

I would try it two more times. One with just the first part of the query and one with the second. Something still tells me that backslash is trouble.

Test #1 use this:

  rel.addEncodedQuery('u_hierarchypath=OPERATING SYSTEM \ AIX');

Test #2 use this:

  rel.addEncodedQuery('u_cmdb_class_name=u_cmdb_ci_logical_partition');

Let me know how many records you get counted from each of those.

[Mrman]

Hi Chuck,

Thanks for your patience.

I tested in both cases. below is the results.

Test #1 use this: rows retrieved :0

  rel.addEncodedQuery('u_hierarchypath=OPERATING SYSTEM \ AIX');

Test #2 use this:rows retrieved :50

  rel.addEncodedQuery('u_cmdb_class_name=u_cmdb_ci_logical_partition');

Please guide.

[Chuck Tomasi]

Thank you. This proves my theory that backslash is being a problem.

Let me do a little testing to see what I can come up with for a fix out of this.

[Mrman]

Ok Thanks Chuck. I will be waiting for your response. Please Guide as I am not able to find a solution for this.