function onChange(control, oldValue, newValue, isLoading) { if (isLoading || newValue == '') { return; } var sname=g_form.getValue("bigproject"); var ga=new GlideAjax('query'); ga.addParam('sysparm_name','querytable_info'); ga.addParam('sysparm_getName',sname); ga.getXML(showDescription); function showDescription(serverResponse){ var result=serverResponse.responseXML.getElementsByTagName("result"); var b_mid=result[0].getAttribute("q_mid"); //alert(b_mid); ga.addParam('sysparm_getId',b_mid); ga.getXML(callback); function callback(response){ var m_name=''; var answer=response.responseXML.getElementsByTagName("ans"); g_form.clearOptions("mPro"); for(var i=0;i<answer.length;i++){ m_name=answer[i].getAttribute("q_name"); g_form.addOption("mPro",m_name,m_name); } } } //Type appropriate comment here, and begin script below }
var querymytable = Class.create(); querymytable.prototype = Object.extendsObject(global.AbstractAjaxProcessor, { querytable_info: function(){ var result=this.newItem("result"); var applyername = this.getParameter('getName'); var gr=new GlideRecord('x_178251_my_applic_x_178251_my_applic'); gr.addQuery('staffname',applyername); gr.query(); while(gr.next()){ result.setAttribute("tel",gr.telnum); result.setAttribute("fax",gr.fax); result.setAttribute("location",gr.location); result.setAttribute("deptname",gr.departmentnum); } }, type:'querymytable' });