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?

[Abhinay Erra]

Yes, getUser() methods always come in handy.

[Uncle Rob]

Why do you need getUser() followed by getUserByID()?   Don't both get you the entire user object?

[Abhinay Erra]

We need getUserByID() in the cases where the created by is a different user from the logged in user. If we use gs.getUser().getDisplayName(), it would get the display name of logged in user.

[Uncle Rob]

Right, but both get a User object, right?   So why have both, simultaneously?

[Abhinay Erra]

Yes, both get a user object. When you say why use simultaneously, you mean do something like this instead of that

var ourUser = gs.getUser();

ourUser = ourUser. ­getUserByID( ­'abel.tuter');

gs.print(ourUser.getDisplayName());