1 ACCEPTED SOLUTION
@VikramM1 Try the following, just change the table names according to yours.
Reference Qualifier in Catalog item:
Script Include:
var FilterStates = Class.create();
FilterStates.prototype = {
getStatesByCountry: function(country) {
//You check if the country is empty. If it is you don't include it in the reference qualifier and return.
if (!country) return '';
var stateList = [];
var stateGr = new GlideRecord('your_state_table');
stateGr.addQuery('your_country_field', country);
stateGr.query();
while (stateGr.next()) {
stateList.push(stateGr.getUniqueValue());
}
return "sys_idIN" + stateList.join(',');
},
type: 'FilterStates'
};I hope this answers your question! 🙂
If it does, kindly mark it as answered.
