[buddypress-trac] [BuddyPress] #3126: Sorting users alphabetically produces inconsistent results

[buddypress-trac at lists.automattic.com]

#3126: Sorting users alphabetically produces inconsistent results
-----------------------+-----------------------------
  Reporter:  dimitryz  |      Owner:
      Type:  defect    |     Status:  new
  Priority:  normal    |  Milestone:  Awaiting Review
 Component:  Core      |    Version:  1.2.8
Resolution:            |   Keywords:  needs-patch
-----------------------+-----------------------------

Comment (by dimitryz):

 There will have to be a left join in there like:

 {{{
 #!php
 "LEFT JOIN {$bp->profile->table_name_data} name_field
         ON name_field.field_id = 1
        AND name_field.user_id = u.id"
 }}}

 Then the ordering...

 {{{
 #!php
 "ORDER BY username"
 }}}

 Finally, the select statement

 {{{
 #!php
 "name_field.value AS 'username'"
 }}}

-- 
Ticket URL: <https://trac.buddypress.org/ticket/3126#comment:3>
BuddyPress <http://buddypress.org/>
BuddyPress