protected String getUserFullNameExpression(TableAlias users) {

        //use coalesce in case any of the name columns are null
        String template = generateTrim(
            generateConcat("COALESCE(%1$s, '')", "' '", "COALESCE(%2$s, '')", "' ('", "%3$s", "')'"));
        return String.format(
            template,
            users.column(colFirstName()),
            users.column(colLastName()),
            users.column(colName()));
    }
protected String getUserFullNameExpression ( TableAlias users ) { String template = generateTrim ( generateConcat ( "COALESCE(%1$s, '')" , "' '" , "COALESCE(%2$s, '')" , "' ('" , "%3$s" , "')'" ) ) ; return String . format ( template , users . column ( colFirstName ( ) ) , users . column ( colLastName ( ) ) , users . column ( colName ( ) ) ) ; }
Returns the SQL expression for generating the user's full name in the format
'firstname lastname (loginname)'.<p>

@param users the user table alias

@return the expression for generating the user's full name