0

CLINT SCRIPT :
function onLoad() {
    //Type appropriate comment here, and begin script below
         var usrInfo = new GlideAjax('getuserInfo');
    usrInfo.addParam('sysparm_name', 'getUserPersonalInfo');
    usrInfo.addParam('sysparm_user', g_user.userID);
    usrInfo.getXML(getBase);
     function getBase(response) {
         var answer = response.responseXML.documentElement.getAttribute("answer");
        var result = JSON.parse(answer);
         for (var fieldName in result) {
            g_form.setValue(fieldName, result[fieldName]);
        }
     }
 SCRIPT INCLUDE FUNCTION :
 getInfo: function() {
        var data = {};
        var id = this.getParameter("sysparm_user");
        var gr = new GlideRecord('sys_user');
        gr.addEncodedQuery('sys_id=' + id);
        gr.query();
        if (gr.next()) {
            data.mobile = gr.getValue('mobile_phone');
            data.user_name = gr.getValue('user_name'); //Data.User_name - backend name of variable of Record producer or catlog item
            var gr1 = new GlideRecord('cmn_cost_center');
            gr1.addEncodedQuery('sys_id=' + gr.getValue('cost_center'));
            gr1.query();
            if (gr1.next()) {
                data.cost_center = gr1.getValue('code');
            }
             var hrProf = new GlideRecord('sn_hr_core_profile');
            hrProf.addEncodedQuery('user=' + id);
            hrProf.query();
            if (hrProf.next()) {
                data.title_name = hrProf.getDisplayValue('position');
            }
data.union_code = gr.getDisplayValue('u_union_code');
             if (gr.company == '56884ceadbcc5380051eff971d961977' || gr.company == '595892a4db381380051eff971d9619da') {
                data.company = true;
            } else {
                data.company = false;
            }
        }
        var json = new global.JSON();
        var obj = json.encode(data);
        return obj;
    },
 getUserPersonalInfo: function() {
         try {
            var data = {};
            var id = this.getParameter("sysparm_user") || gs.getUserID();
            var userRec = new GlideRecord('sys_user');
            if (userRec.get(id)) {
                 //User Fields
                data.first_name = userRec.getValue("first_name") || "";
                data.middle_name = userRec.getValue("middle_name") || "";
                             //HR Profile Fields
                var hrProfileRec = new GlideRecord("sn_hr_core_profile");
                hrProfileRec.addQuery("user", userRec.getUniqueValue());
                hrProfileRec.query();
                if (hrProfileRec.next()) {
                    data.ght_id = hrProfileRec.getValue("sn_y");
                            var address = hrProfileRec.getValue("address") || "";
                    if (address.toString().indexOf(",") > 0) {
                        data.home_address_1 = address.toString().split(",")[0];
                        data.home_address_2 = address.toString().split(",")[1];
} else {
                        data.home_address_1 = address.toString();
                        data.home_address_2 = "";
                    }
                    var city = hrProfileRec.getValue("city") || "";
                    if (city != "") {
                        if (hrProfileRec.getValue("city").toString().indexOf(",") > 0) {
                            var arr = hrProfileRec.getValue("city").toString().split(",");
                            data.home_city = arr[0] || "";
                            data.home_state = arr[1] || "";
                         } else {
                            data.home_city = hrProfileRec.getValue("city") || "";
                            data.home_state = hrProfileRec.getValue("state") || "";
                        }
                    }

Script Include Example – Get User Data
ControlF5 Answered question April 12, 2024