reference in catalog items 联动

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'
});
原文地址:https://www.cnblogs.com/yanweichen/p/8007173.html