Hello All,

if you need to populate select box variable from a table, in this scenario below scripts will be helpful

ScriptInclude

var assetRequisitionUtils = Class.create();

assetRequisitionUtils.prototype = Object.extendsObject(AbstractAjaxProcessor, {

getBuildingNamesByCity : function(){ var buildins = []; var city = this.getParameter("sys_param_city"); var loc = new GlideRecord("u_geographical_hierarchy1"); loc.addQuery("u_city", city); loc.query(); while(loc.next()){ buildins.push(loc.u_building.toString()); } var dups = []; var arr = buildins.filter(function(el) { if (dups.indexOf(el) == -1) { dups.push(el); } }); return dups.toString(); }, getFloorByBuildings : function(){ var floors = []; var building = this.getParameter("sys_param_building"); var loc = new GlideRecord("u_geographical_hierarchy1"); loc.addQuery("u_building", building); loc.query(); while(loc.next()){ floors.push(loc.u_floor_name.toString()); } var dups = []; var arr = floors.filter(function(el) { if (dups.indexOf(el) == -1) { dups.push(el); } }); return dups.toString(); }, type: 'assetRequisitionUtils'

});

OnChange Client Script

function onChange(control, oldValue, newValue, isLoading) { if (isLoading || newValue == '') { g_form.clearOptions('floor_asset_requisition'); g_form.addOption('floor_asset_requisition', '', '--None--'); return; }var ga = new GlideAjax('assetRequisitionUtils');ga.addParam('sysparm_name', 'getFloorByBuildings');ga.addParam('sys_param_building', newValue);ga.getXML(HelloWorldParse); function HelloWorldParse(response) { var answer = response.responseXML.documentElement.getAttribute("answer"); //alert(answer); var floors = answer.toString().trim().split(','); g_form.clearOptions('floor_asset_requisition'); g_form.addOption('floor_asset_requisition', '', '--None--'); for(var index = 0; index < floors.length; index++){ //alert(buildins[index]); //return; g_form.addOption('floor_asset_requisition', floors[index], floors[index]); }}

}

Thanks