Modern way of showing user in grids

[Alexander Obuhovich]

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:

'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 username otherwise.

--
Best Regards,

http://www.in-portal.com
http://www.alex-time.com

[Phil -- wbtc.fr --]

do you intend to make 1 admin grid column then?

2011/11/21 Alexander Obuhovich <aik....@gmail.com>

[Alexander Obuhovich]

Nope, won't be adding such column, where it's missing.

This is only for case, when we have this column and always display username, but could display firstname+lastname for easy managing.

[Dmitry A.]

Hi guys,

I like the idea!

DA