Hello Array List query

[DB1]

Hello all,

I am trying to query 2 different tables and join them together. Can someone help me on the same as Union does not seem to work. Here's my code below

@Jaspal Singh @Saurav9 @Saurav11 @The SN Nerd @Ankur Bawiskar 

var arr = [];
var arr1 =[]; 
var sysid ='c6109fc84762111083fea946926d430f';
var gr= new GlideRecord('cmdb_rel_person');   //Pass table 1 name here
gr.addQuery('ci','IN','0ef85272db92fb00de9f1bbf29961968,f1df074a0f490700552ec4dce1050e48');
gr.addQuery('user',sysid);
gr.query();
while(gr.next())
{
gs.print(arr.push(gr.sys_id()));
//arr.push(gr.sys_id()); 
arr.push(gr.sys_id());
}


var gr1 = new GlideRecord('u_custom_table'); //Pass table name 2 here
gr1.addQuery('u_ci','IN','0ef85272db92fb00de9f1bbf29961968,f1df074a0f490700552ec4dce1050e48');
gr1.addQuery('u_user',sysid);
gr1.query();
while(gr1.next())
{
gs.print(arr1.push(gr1.sys_id()));
arr1.push(gr1.sys_id())
}
var arrayUtil = new ArrayUtil();
gs.print(arrayUtil.union(arr,arr1));
  

Thanks,

[Muhammad Khan · Accepted solution]

Try with below script.

var arr = [];
var arr1 =[]; 
var sysid ='c6109fc84762111083fea946926d430f';
var gr= new GlideRecord('cmdb_rel_person');   //Pass table 1 name here
gr.addQuery('ci','IN','0ef85272db92fb00de9f1bbf29961968,f1df074a0f490700552ec4dce1050e48');
gr.addQuery('user',sysid);
gr.query();
while(gr.next())
{
//gs.print(arr.push(gr.sys_id()));
//arr.push(gr.sys_id()); 
arr.push(gr.sys_id.toString());
}


var gr1 = new GlideRecord('u_custom_table'); //Pass table name 2 here
gr1.addQuery('u_ci','IN','0ef85272db92fb00de9f1bbf29961968,f1df074a0f490700552ec4dce1050e48');
gr1.addQuery('u_user',sysid);
gr1.query();
while(gr1.next())
{
//gs.print(arr1.push(gr1.sys_id));
arr1.push(gr1.sys_id.toString())
}
var arrayUtil = new ArrayUtil();
gs.print(arrayUtil.union(arr,arr1));

Replaced

arr.push(gr.sys_id())

With

arr.push(gr.sys_id.toString())

Replaced 

arr1.push(gr1.sys_id())

With

arr1.push(gr1.sys_id.toString())

[DB1]

It worked! Thank you