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
Sorry, you do not have permission to read comments.