How to write a reference qualifier for a Catalog Item variable?

[Chaithra Srini1]

Hi Everyone,

I have a use case to display list of Locations in the Locations reference list based on the requested for company. I have written a script include and called it in an advanced qualifier as below, but it seems to be not working. Could anyone please provide any insights on why? 

Thank you in advance.

Below are the screenshots

function myScriptInclude() {
var site = ' ';
var b = gs.getUser(); //Logged-in user

var loc = new GlideRecord('cmn_location');
loc.addQuery('company',b.getCompanyID());
loc.query();

while(loc.next()) {
if (site.length > 0) {
//build a comma separated string of groups if there is more than one
site += (',' + loc.company);
}
else {
site = loc.company;
}
}
// return Groups where assigned to is in those groups we use IN for lists
return 'sys_idIN' + site;
}

[Swadesh Saraf2]

javascript:new <scriptIncludeName>().<scriptIncludeFunction>()

You will need to call script include like this.

[Prateek kumar]

I would do this:

javascript: new myScriptInclude().getLocations()

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

    getLocations: function() {
        var site = [];
        var b = gs.getUser(); //Logged-in user

        var loc = new GlideRecord('cmn_location');
        loc.addQuery('company', b.getCompanyID());
        loc.query();

        while (loc.next()) {
           site.push(loc.company.toString());
            } 
		
   
        // return Groups where assigned to is in those groups we use IN for lists
        return 'sys_idIN' + site;
    },

    type: 'myScriptInclude'
});

[Chaithra Srini1]

Thanks for your response Prateek.

I tried above method and it didn't fetch any Locations. Guess something is missing. 

[Chaithra Srini1]

Hi all,

I am missing something here, couldn't fetch location records. Something isn't working while returning values. Could someone help me please?

Regards,

Chaithra