Author sort order for a work with co-creators does not agree with its byline

Description

Steps to reproduce

  1. Log in as testy

  2. Post a work with a co-creator newer than testy, whose name is far enough from "testy" in the alphabetical order (e.g. "bluewinterday")

  3. Go to testy's work listing (or any listing where the new work can be seen)

  4. Sort by: Author, then "Sort and Filter"

What happens

The work will be listed around T (for testy).

What should happen

The work should be listed around B (for bluewinterday), since the work's byline reads "bluewinterday, testy".

Notes

Byline sorts the authors. The field authors_to_sort_on does not sort the authors, so we seemingly get them ordered by primary key.

Environment

None

Status

Assignee

redsummernight

Reporter

redsummernight

Roadmap

Search

Priority

Medium

Affects versions

Fix versions

Components

BackEnd

Difficulty

Medium

Required Access Level

None

Milestone

Internal 0.9
Configure