Getting Created By 'name' of sys_created_by on sysapproval_approver table

xiaix · ‎08-15-2016

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 · ‎08-15-2016

You can use use mail script and put this script in there

template.print(gs.getUser(). getUserByID(current.sys_created_by).getDisplayName());

View solution in original post

Uncle Rob · ‎08-15-2016

An easier way would be to use Opened_By, which is an actual reference, and unless there's been significant alteration from OOB, shouldn't be different than the Created By.

xiaix · ‎08-15-2016

That'd be awesome if Opened By was a field on the sysapproval_approver table.

Uncle Rob · ‎08-15-2016

Are the approvals being manually created?

xiaix · ‎08-15-2016

No, by a workflow (Approval - User).

The record creating table does not extend the task table, so the "Approval for" on the sysapproval_approver is blank. I'm triggering the notification as such:

The entire workflow and approval system works great, I'm just trying to get the name of Created By, not their user id.

I know, if this extended the task table then I could use ${sysapproval.opened_by.name}, but alas, I'm not.