Passing an Array to GlideRecord Query in the Workflow

[VAIGAI_KOTHANDA]

HI,

We need to pass an array value to the GlideRecord Query in the Workflow. We have used the following code to pass an array value.

var answer = [];
var app = current.functions.getDisplayValue();
var array = app.split(",");
//var array1 = new ArrayUtil().unique(array);
var grBS = new GlideRecord('u_ecare_choicevalues');

for (var i=0; i < array.length; i++) {
grBS.addQuery('u_name', array[i]);

grBS.query();

while(grBS.next())
  {
  answer.push(grBS.approval_group);
  }
}

Here the problem is , its taking the first value and its not taking running for the other values.

Can you please help us fix this issue.

[edwin_munoz]

Hi Vaigai, I think you need to declare grBS inside the for loop.

[Harish Murikina]

Try below code now . It should work.

var answer = [];
var app = current.functions.getDisplayValue();
var arrayval = app.split(",");

//var array1 = new ArrayUtil().unique(array);

var len = arrayval.length;

for (var i=0; len>i; i++)

{

      var grBS = new GlideRecord('u_ecare_choicevalues');
      grBS.addQuery('u_name', arrayval[i]);

      grBS.query();

      while(grBS.next())
    {
          answer.push(grBS.approval_group);
    }

}

[VAIGAI_KOTHANDA]

Hi Harish,

Below is the explanation of the requirement:-

For Example:- We have more than one value in the Glide List A. And suppose the values are 1 and 2.

Each Value 1 and 2 are having a field called Approval group.

We are trying to fetch both the Approval Groups, in case 1 and 2 are selected in the Glide list A.

Can you now explain if the code provided by you will help?

Actually i tried that and it didn't help.

Edwin Munoz

Thanks,

Vaigai

[Harish Murikina]

Have you tried the above code? it doesn't work?