How to iterate array using for loop and pass each value in a gliderecord

[Laukik Udpikar]

Hello Experts,

I need help in below script;

arr = ['sysid,'sysid'];

I want to create a for loop and get each sysid to be passed in a gliderecord and add each value as part of encodeded query as well,

Need help in building it

[Ankur Bawiskar]

Hi,

so what have you started with and where are you stuck?

Regards
Ankur

[_ChrisHelming]

I'm going to guess they're stuck at "missing ] after element list" since their array isn't valid 😉

[Laukik Udpikar]

var arr = ['sysid','sysid'];

var child = [];

for(var j =0; j < arr.length ; j++){

//var eq = 'parent!=NULL^active=true^parent='+arr[j];

var gr = new GlideRecord('table');

//gr.addEncodedQuery(eq);

gr.addQuery('parent',arr[j]);

gr.query();

while(gr.next()){

child.push(gr.sys_id);

}

}

[Ankur Bawiskar]

@Laukik Udpikar 

try this

var arr = ['sysid1','sysid2'];

var child = [];

var gr = new GlideRecord('table');
gr.addEncodedQuery('parent!=NULL^active=true^parentIN' + arr.toString());
gr.query();
while(gr.next()){
	child.push(gr.sys_id.toString());
}

Regards
Ankur