[buddypress-trac] [BuddyPress] #5093: Leading whitespace in display names messes with alphabetical sort

buddypress-trac noreply at wordpress.org
Wed Jul 10 15:43:46 UTC 2013


#5093: Leading whitespace in display names messes with alphabetical sort
--------------------------+-------------------------------------
 Reporter:  boonebgorges  |      Owner:
     Type:  enhancement   |     Status:  new
 Priority:  lowest        |  Milestone:  Future Release
Component:  Core          |    Version:
 Severity:  minor         |   Keywords:  has-patch needs-testing
--------------------------+-------------------------------------
 If a username is entered as " Boone" rather than "Boone", it'll show up
 first in the list when doing an alphabetical sort. In my experience, a
 name is typically entered with leading whitespace by accident. But it
 could also be used as a sort of hack to get your profile to the top of the
 list. We might consider trimming this whitespace, either on the way in (at
 the time of profile save), or at the time of query:

 {{{
 ORDER BY LTRIM(u.value)
 }}}

 Are there legit reasons for wanting leading whitespace? Would the latter
 query cause performance issues at scale? Needs testing.

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/5093>
BuddyPress <http://buddypress.org/>
BuddyPress


More information about the buddypress-trac mailing list