AnsweredAssumed Answered

How to copy Last updated by maintaining format

Question asked by urmas on Sep 21, 2016
Latest reply on Sep 21, 2016 by am1

If you look at the last_updated_by field in the database it appears to contain the user ID.

If you put that in an object based portlet it displays as Full name or Last_name ||', '|| First_name


If you copy the field content to a custom field with update in a gel script the content in the db still looks as user ID.


However when you put it in an object based portlet it is displayed as username.

Note that the custom field is associated with Browse Resources sch_browse_users lookup.


How can I display the content as Full name in the same format as Last updated by?

If the field were not associated with a lookup but free text the format could be handled in the update query in gel.