Userliste Sortierung nach Vorname

[Marcus]

Ist es möglich die Userliste nach Vornamen zu Sortieren ?

Gruß Marcus

[Marcus]

Bin nun hingegangen und habe in der members_data.php das feld FIRST_NAME / LAST_NAME getauscht:

Code: Alles auswählen

// show all members (not accepted users should not be shown)
$mainSql = 'SELECT usr_id, last_name.usd_value || \', \' || first_name.usd_value AS name,
               email.usd_value AS email, gender.usd_value AS gender, birthday.usd_value AS birthday,
               usr_login_name, COALESCE(usr_timestamp_change, usr_timestamp_create) AS timestamp,
               '.$memberOfThisOrganizationSelect.' AS member_this_orga,
               '.$memberOfOtherOrganizationSelect.' AS member_other_orga
          FROM '.TBL_USERS.'
    INNER JOIN '.TBL_USER_DATA.' AS last_name
            ON last_name.usd_usr_id = usr_id
           AND last_name.usd_usf_id = '.$gProfileFields->getProperty('FIRST_NAME, 'usf_id').'
    INNER JOIN '.TBL_USER_DATA.' AS first_name
            ON first_name.usd_usr_id = usr_id
           AND first_name.usd_usf_id = '.$gProfileFields->getProperty('LAST_NAME', 'usf_id').'
     LEFT JOIN '.TBL_USER_DATA.' AS email
            ON email.usd_usr_id = usr_id
           AND email.usd_usf_id = '.$gProfileFields->getProperty('EMAIL', 'usf_id').'
     LEFT JOIN '.TBL_USER_DATA.' AS gender
            ON gender.usd_usr_id = usr_id
           AND gender.usd_usf_id = '.$gProfileFields->getProperty('GENDER', 'usf_id').'
     LEFT JOIN '.TBL_USER_DATA.' AS birthday
            ON birthday.usd_usr_id = usr_id
           AND birthday.usd_usf_id = '.$gProfileFields->getProperty('BIRTHDAY', 'usf_id').'
         WHERE usr_valid = 1
               '.$memberOfThisOrganizationCondition;

Jetzt ist die Userverwaltung nach Vornamen Sortiert.