How to get the sys_id using glide record

[Jeni Sebastian]

Hello everyone!

I would like to know how to get the sys_id of the user using gliderecord because i tried to get the value of the sys_id but its not showing the value  in "notifs.u_user".

Below, Im creating new records in custom table 2 and I need to set the "notifs.u_user" value to the sys_id of the user that is in the custom table 1.

Here's what I did :

var gr = new GlideRecord('custom table 1');
gr.addEncodedQuery('nameSTARTSWITHJ');
gr.query();

var upd = gr.u_apprentice_eid.getValue('sys_id'); // in this line I tried to get the sys_id of the user

if(gr.next()){
var notifs = new GlideRecord('custom table 2');

notifs.initialize();
notifs.u_send_date = '2022-08-26';
notifs.u_user = upd;  
notifs.insert();
}

[Ankur Bawiskar]

@Jeni Sebastian 

Could you close your earlier question if it is answered?

Autopopulate field using Scheduled Job

Regards
Ankur

[Hitoshi Ozawa]

Hi Jeni,

If field "u_apprentice_eid" is a reference to the user table, then below script will set sys_id of a user to field u_user.

var gr = new GlideRecord('custom table 1');
gr.addEncodedQuery('nameSTARTSWITHJ');
gr.query();
if(gr.next()){
	var upd = gr.u_apprentice_eid.sys_id.toString(); // in this line I tried to get the sys_id of the user
	var notifs = new GlideRecord('custom table 2');
	notifs.initialize();
	notifs.u_send_date = '2022-08-26';
	notifs.u_user = upd;  
	notifs.insert();
}