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.

[rog]

I have tried now it is getting some error but still am able to select all the locations of all the countries.

[Joni5]

Weird. Now before changing anything could you get me a screenshot of your current scripts?

The reference qualifier as it is and the script include with all the options visible as well.

[rog]

Hi Joni,

Please find the screnshots in the attachments.

[Jim Coyne · Accepted solution]

You should be able to just set the "Reference qual" field to:

javascript:"country=" + current.variables.countries.getDisplayValue();

[rog]

HI Jim,

you mean just deactivate the script include and update the ref qualifier?