Referance field returns sys id need display name

[stuartsisk]

I have a Record Producer for requesting the creation of a new employee (on boarding).   The Record Producer fires a workflow to create tasks associated with the process.   Information from the Record Producer is passed to the tasks via script (

[stuartsisk]

... All the fields pass correctly except the "Manager" field.   This is a reference field from the Sys_User table.   This passes a sys id.   I need the display name.   I have not found a way to convert the sys id to the display name.

[Michael Fry1]

You should be able to pass manager.name to get the display value but not sure if you are using variable or how you are passing it. Normally adding .name would work.

[Deepak Ingale1 · Accepted solution]

I Stuart,

I am not able to see the script section you have provided. Not sure if it is missing in the question itself or I am not able to see it.

Since your sys_id is being passed to the workflow, you can get the display name of the user record by using following code.

var gr = new GlideRecord('sys_user'); // initialize the object of the record.

gr.get('sys_id'); // pass on the sys_id of the manager here

gs.log(gr.getDisplayValue()); // log a manager record display name for debug / test purpose

var display = gr.getDisplayValue(); // store the display name in a variable

I hope this helps you to proceed with your workflow script.

[stuartsisk]

That worked like a charm.   Thank you very much!