[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:  Future Release
 Component:  Core      |    Version:  1.2.8
Resolution:            |   Keywords:  needs-patch
-----------------------+----------------------------
Changes (by DJPaul):

 * keywords:  has-patch needs-testing => needs-patch
 * milestone:  1.3 => Future Release


Comment:

 The problem occurs only when searching. The issues concerns when
 $sql['where_searchterms'] is set. The display_name solution isn't
 appropriate because, as cnorris23 said, those fields are not guaranteed to
 match for a user. The join that dimitryz proposes is what is already
 implemented.
 I have spent a long time looking at fixing this properly and cannot find a
 way of doing it while the user's name (via
 BP_XPROFILE_FULLNAME_FIELD_NAME) and the rest of the profile fields are in
 the same table. It may be possible with a subquery but I am not sure, plus
 I don't know how slow those things are. Punting the ticket to take another
 look at in a future 1.3.x release.

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