reference qualifier shows only one value even though I have a lot returning

[samadam]

I am setting a reference qualifier using script include, I have multiple values returning in the array but only shows one value in the reference field. when i print to logs I can see multiple sys_ids. Any idea how to fix?

           var OArray1 = [];

            var ga1 = new GlideRecord('office_space');                 

            ga1.addEncodedQuery('u_active=true^level=2');

           ga1.query();

            while (ga1.next()){

               OArray1.push(ga1.sys_id);

            }

           return 'sys_idIN' + OArray1;

[Sumanth16 · Accepted solution]

Hi @samadam ,

Can you update your script as belows:

var Filterofficespace = Class.create();
Filterofficespace.prototype = {
initialize: function() {
},

Filterofficespace:function(){
var gp = [];
var xyz = current.u_name;

if(!xyz)
return;
if(xyz){
var gr = new GlideRecord('cmdb_ci');
gr.addQuery('assigned_to', current.u_name);//replace with your query
gr.query();
while(gr.next()) {
gp.push(gr.sys_id.toString());

}
return 'sys_idIN' + gp;
}
},
type: 'Filterofficespace'
};

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda

[Reus]

Hi @Sam 

Try to replace this line 'OArray1.push(ga1.sys_id);' with 'OArray1.push(ga1.sys_id.toString());' and check. Also can add the log statement (gs.log(OArray1)) before the return.