How to print data received from script include in Dropdown

[Community Alums]

Hello All,

We have two fields on the form, and referring to same table

1) Business Unit - Lookup Select Box

2) Country - Lookup Select Box

I have written below scripts 

Script include - 

country: function() {
var bu = this.getParameter('sysparm_bu');
gs.log("I am Business" + bu);
//var arr = [];
var gr = new GlideAggregate('u_oracle_financial_approvals');
gr.addQuery('u_business_unit', bu);
gr.groupBy('u_country');
gr.query();
gs.log("Tejas" + gr);

var arr = [];
while (gr.next()) {
var obj = gr.getValue('u_country').toString()+"";
arr.push(obj);
gs.log("Result", +arr);

}
var data = JSON.stringify(arr);
gs.log('Final Result', data);
return data;
},

OnChange Catalog Client Script - 

var rf = g_form.getDisplayValue('u_business_unit');
alert('Hi, I am ' + rf);
var ga = new GlideAjax('Oracle_Business_Units');
ga.addParam('sysparm_name', 'country');
alert('Hi, I am ' + rf);
ga.addParam('sysparm_bu', rf);
ga.getXMLAnswer(setAnswer);

function setAnswer(response) {
var arr = JSON.parse(response);
//var res = arr.split('#');
g_form.setValue('country', arr);

}

We are getting output in below format

Issue - We want highlighted data to be printed as dropdown values and remove the above values which are populating from table.

Please help!

Thanks,

Tejas

[Community Alums]

Hi @Fazal Mohammad ,

It says "No matches found"

[Fazal Mohammad]

@Community Alums 

Can you please attach the Script Include and the Field (sys_dictionary) as XMLs here?

[Community Alums]

Hi @Fazal Mohammad ,

Script include -

var oracle_bu = Class.create();
oracle_bu.prototype = {
initialize: function() {},
country: function(current) {

gs.info("I am Business" + current.variables.u_business_unit);

var gr = new GlideAggregate('u_oracle_financial_approvals');
//gr.addQuery('u_business_unit', current.variables.u_business_unit);
gr.groupBy('u_country');
gr.query();
gs.log("Tejas" + gr);

var arr = [];
while (gr.next()) {
var obj = gr.getValue('u_country').toString() + " ";
arr.push(obj);
gs.log("Result", +arr);

}
var data = arr.join();
gs.info('Final Result', data);
return data;
},

type: 'oracle_bu'
};

[Fazal Mohammad]

@Community Alums Did you made this script include client callable true?

[Community Alums]

Hi @Fazal Mohammad 

Initially I made true but I unchecked that later.