Choices of location should be made available based on the country selected in the list collector field.

[rog]

Hi all,

I have a requirement where in we need to populate the location (reference to cmn_location) value based on the selection of country (reference to core_country). If for example countries Japan and China are selected then on the locations that are active under these countries should be available for selection in location field.

I got to know that we need to achieve this through script include and advance reference qualifier since the location field is a reference field. Please note that the country field is a List Collector.

Based on the inputs we have written the below code:

var getCountryLocation = Class.create();
getCountryLocation.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getCountry1 : function ()
{
var sys_id_list=[];
var cou;
var a=current.variables.countries.getDisplayValue();
var gr1=new GlideRecord('cmn_location');
gr1.addQuery('country',a);
gr1.query();
while(gr1.next())
{
sys_id_list.push(gr1.getValue('sys_id'));
}
return 'sys_idIN'+sys_id_list.toString();
},

type: 'getCountryLocation'
});

calling it in the reference qualifier,

javascript : new getCountryLocation().getCountry1();

please suggest. Thanks in advance.

[Joni5]

What is the name of your script include? It should be getCountryLocation.

[rog]

It is getCountryLocation. Please refer the attached attachment.

[Joni5]

Try changing the accessible from value to All application scopes.

[rog]

tried that one also, it is triggering the same error:

org.mozilla.javascript.EcmaError: "getCountryLocation" is not defined.
Caused by error in <refname> at line 1

==> 1: new getCountryLocation().getCountry1();

[Joni5]

Just for the heck of it try with the all application scopes and change the query from

javascript: new getCountryLocation().getCountry1();

to

javascript: new sn_hr_core.getCountryLocation().getCountry1();