Getting Created By 'name' of sys_created_by on sysapproval_approver table

[xiaix]

For System Notifications, on the sysapproval_approver table.

The field, "Created By"   (sys_created_by), is a string field, not a reference.

The Created By displays the "user_id" of the user, instead of their "name".

How can I get the name?

In the body of the email I have:

Created By:   ${sys_created_by.name}     =     of course since this isn't a reference field, it returns nothing.

Created By:   ${sys_created_by}     =     this returns the user_id, like   489593

Can I use the good 'ole getReference() function in an email notification?

[Uncle Rob]

More like... why can't I just do something like ...

gs.print(getUserByID(current.sys_created_by).getDisplayValue());

[Abhinay Erra]

We need to first retrieve the current user, and then use that object's getUserByID method to fetch a different user using the user_name field or sys_id. This is straight out of wiki

Getting a User Object - ServiceNow Wiki

[xiaix]

This worked like a charm!

[Abhinay Erra]

Glad you got this working