Imported From: http://groups.google.com/group/in-portal-dev/browse_thread/thread/ed407b4ac446715a#
Most of data, that can be added from Front-End has "CreatedById" column, that
stores ID of user, who created that record.
In all places we use LEFT JOIN to "PortalUser" table to speed up user data
retrieval. However we don't centrally use universal scheme for user data
display.
Here is the one, that I've developed on one of projects I was working on:
| Code Block |
|---|
'CASE %1$s.CreatedById WHEN ' . USER_ROOT . ' THEN "root" WHEN ' . |
...
USER_GUEST . ' THEN "Guest" ELSE IF(CONCAT(pu.FirstName, pu.LastName) <> |
...
"", CONCAT(pu.FirstName, " ", pu.LastName), pu.Username) END' |
Above SQL shows user's firstname & lastname only when they are filled and
shows and shows username otherwise.
--
Best Regards,