Skip to content

Ordering of Individual Members is unexpected #2076

Open
@thibaudcolas

Description

@thibaudcolas

On the Individual Members page and in the Django admin, the sorting of the names seems to ignore spaces. This leads to surprising results when people share a first name (or close), for example:

  1. Tim Allen
  2. Tim Baxter
  3. Tim Graham
  4. Tim Kamanin
  5. Timo Zimmermann
  6. Tim Schilling

I would have expected Timo to either be at the start or (most likely) end of that list, not in the middle.


Investigating with @ontowhee, we suspect it’s a matter of how collation is set up (the SQL for the ordering is just ORDER BY "members_individualmember"."name" ASC). Not sure if we want to change the collation on the field with db_collation, or for this specific query.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions