I need to populate a dropdown of courses, based-on the term selected. I have a GlideAjax call to fetch the data and then use the addOption() function to populate the value in the 'u_course' field. However, I am unable to filer courses offered by 'u_term_code'... The same list of courses is populated, regardless of term selected.
What am I missing?
Client Script:
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
var ga = new GlideAjax('GetListValue');
ga.addParam('sysparm_name','getList');
ga.addParam('sysparm_term ', newValue);
ga.getXML(fillDetails);
function fillDetails(serverResponse){
var answer = serverResponse.responseXML.documentElement.getAttribute("answer");
var choiceval = answer.split(',');
for(var i = 0; choiceval.length > i ; i++){
g_form.addOption('u_course', choiceval[i], choiceval[i], [i]);
}
}
}
Client Callable Script Include:
var GetListValue = Class.create();
GetListValue.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getList : function() {
var courses = [];
var gr = new GlideRecord('u_bsu_courses');
gr.addQuery('u_term_code', this.getParameter('sysparm_term'));
gr.query();
while(gr.next())
courses.push(gr.name.toString());
return courses;
},
type: 'GetListValue'
});
