question Reference qualifier for list collector via script include does not work in Developer forum

Reference qualifier for list collector via script include does not work

Payal5 — Tue, 30 Jul 2019 06:24:26 GMT

Hi All,

I am looking for help in identifying any issue with the following piece of Script Include code. I have two variable in 'Select location' (references to cmn_location table) and 'Select equipments' (Type-List collector (u_location_equipments)).

I have requirement to create reference qualifier on 'select equipments' variable based on 'select location'.For ex. If location is AC - FF – 001 then it should show only Projector, Video Conferencing Solution (WebEX), Table MIC.

I'm using below script include but it is not working,

----------------------------------------------------------------------------

var GetEquipments = Class.create();
GetEquipments.prototype = Object.extendsObject(AbstractAjaxProcessor, {

allEquipments:function(){

var include = '';
var selectedLoc = current.variables.select_location;

var equ = new GlideRecord('u_location_equipments');
equ.addQuery('u_location', selectedLoc);
equ.query();

while(users2.next())
{
include += (',' + equ.u_equipment);
}

//return criteria string
return 'sys_id IN' + include;
},

type: 'GetEquipments'
});

-----------------------------------------------------------------

Re: Reference qualifier for list collector via script include does not work

paulmorris — Tue, 30 Jul 2019 06:34:22 GMT

I have found three bugs:

Incorrect variable name in while loop
Dot-walking in a while loop
space in encoded query

I've also modified your code to use an array instead, as it is a bit tidier.

var GetEquipments = Class.create();
GetEquipments.prototype = Object.extendsObject(AbstractAjaxProcessor, {

allEquipments:function(){
//var include = '';
var include = [];  // Use array, push() & join(",") instead
var selectedLoc = current.variables.select_location;

var equ = new GlideRecord('u_location_equipments');
equ.addQuery('u_location', selectedLoc);
equ.query();

// while(users2.next())   Bug #1 - wrong variable name
while(equ.next()) // replaced with equ
{
//include += (',' + equ.u_equipment); Bug #2 - dot walking in while loop
include.push(equ.getValue('u_equipment')); // use getValue instead 
}

//return criteria string
//return 'sys_id IN' + include; Bug #3 - Erronerous space here
return 'sys_idIN' + include.join(","); // removed space
}, 

type: 'GetEquipments'
});

Re: Reference qualifier for list collector via script include does not work

Payal5 — Tue, 30 Jul 2019 06:45:12 GMT

Hi Paul,

Thanks for the reply.

I updated the code but it is returning "No Matches found" when i set location as AC - FF – 001

Re: Reference qualifier for list collector via script include does not work

AbhishekGardade — Tue, 30 Jul 2019 07:37:32 GMT

Hello Payal,

Just small change in code.

var GetEquipments = Class.create();
GetEquipments.prototype = Object.extendsObject(AbstractAjaxProcessor, {

allEquipments:function(){
//var include = '';
var include = []; // Use array, push() & join(",") instead
var selectedLoc = current.variables.select_location;

var equ = new GlideRecord('u_location_equipments');
equ.addQuery('u_location', selectedLoc);
equ.query();

// while(users2.next()) Bug #1 - wrong variable name
while(equ.next()) // replaced with equ
{
//include += (',' + equ.u_equipment); Bug #2 - dot walking in while loop
include.push(equ.getValue('u_equipment').toString()); // use getValue instead
}

//return criteria string
return 'sys_id IN' + include; Bug
},

type: 'GetEquipments'
});

Also try adding logs to check that you are getting the correct values in array and getrowcount as well

Please mark as Correct Answer/Helpful, if applicable.
Thanks!
Abhishek Gardade

Re: Reference qualifier for list collector via script include does not work

Sanket Khabiya — Tue, 30 Jul 2019 07:46:35 GMT

Hi Payal,

Hope below code helps you!!!

Script Include :
Name : GetEquipments
API Name : global.GetEquipments

--------------------------------------------------------------------
function GetEquipments(){
var array = [];
var location = current.variables.select_location;

var gloc = new GlideRecord('u_location_equipments');
gloc.addEncodedQuery('u_location='+location);
//gs.addInfoMessage(gloc.getEncodedQuery());
gloc.query();
while(gloc.next())
{
array.push(gloc.getValue("u_equipment"));

}
gs.addInfoMessage(array.toString());
return 'sys_idIN' +array;
}

--------------------------------------------------------------------
Add Reference Qualifier on the variable "select_location" :

javascript:global.GetEquipments();

--------------------------------------------------------------------

Regards,
Sanket

Re: Reference qualifier for list collector via script include does not work

paulmorris — Tue, 30 Jul 2019 08:26:51 GMT

Replace this line

include.push(equ.getValue('u_equipment')); // use getValue instead

with this line

include.push(equ.getValue('sys_id')); // use getValue instead

Re: Reference qualifier for list collector via script include does not work

Payal5 — Tue, 30 Jul 2019 08:44:25 GMT

I tried it but still giving No "Matches Found"

Re: Reference qualifier for list collector via script include does not work

AbhishekGardade — Tue, 30 Jul 2019 09:14:27 GMT

Can you share a complete screenshot of the script include?

Thanks,
Abhishek

Re: Reference qualifier for list collector via script include does not work

Payal5 — Tue, 30 Jul 2019 09:15:14 GMT

Resolved. Just need to write below line in "Select Equipments" reference qualifier,

javascript:'u_location='+current.variables.select_location

Re: Reference qualifier for list collector via script include does not work

AbhishekGardade — Tue, 30 Jul 2019 09:17:39 GMT

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.
Thank you,Abhishek