Script returns undefined for reference value

[preethigovi]

Hi Team,

I was learning on scripting where i had uses case to fetch manager (reference to user table) in HR profile and populate on filed on other scoped table

var hrProfileGR = new GlideRecord('sn_hr_core_profile');

hrProfileGR.addQuery('sys_id=04556f50471f1110e72d7116536d43f9');

hrProfileGR.query();

var managerValue = hrProfileGR.getValue('manager');

var userValue = hrProfileGR.getDisplayValue('user')

gs.info('PreeManager value: ' + managerValue);

gs.info('PreeManager2 value: ' + userValue);

Can you point out why its returning null value for managers?

[preethigovi]

@Bhavya11 Its reference to user table.

[Bhavya11]

Hi @preethigovi ,

your script your fetching display value then setting that with the reference field so its not work.

var hrProfileGR = new GlideRecord('sn_hr_core_profile');
hrProfileGR.addQuery('number=HRP3083319^u_managerISEMPTY'); 
gs.info('PT1');
hrProfileGR.query();
if (hrProfileGR.next()) {
gs.info('PT Success');
var userGR = new GlideRecord('sys_user'); 
if (userGR.get(hrProfileGR.user)) {
var hiringManager = userGR.manager; 
hrProfileGR.setValue('u_manager', hiringManager); 
hrProfileGR.update(); // Save changes
gs.info('Hiring Manager set to: ' + hiringManager);
} else {
gs.info('User record not found.');
}
}

[preethigovi]

@Ankur Bawiskar @Bhavya11 

In show xml it shows value but in field its empty.

[Ankur Bawiskar · Accepted solution]

@preethigovi 

use this script

var hrProfileGR = new GlideRecord('sn_hr_core_profile');
hrProfileGR.query();
while (hrProfileGR.next()) {
    var userValue = hrProfileGR.getValue("user");
    var userProfile = new GlideRecord('sys_user');
    if (userProfile.get(userValue)) {
        hrProfileGR.u_manager = userProfile.manager;
        hrProfileGR.update();
    }
}

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@preethigovi 

Hope you are doing good.

Did my reply answer your question?

If my response helped please close the thread by marking appropriate response as correct so that it benefits future readers.