Sorting/filtering of manuscripts doesn't follow current version
When sorting or filtering manuscripts in the Manuscripts page, the data should in most cases come from the latest version of each manuscript. E.g., when sorting by title, it should use the latest version of the title; or when filtering by status, it should use the status of the latest version. The only field where I think this is not appropriate is the created
field, which should be taken from the first version of each manuscript.
The actual observed behaviour is that sorting/filtering is based on the values in the first version of each manuscript. Thus filtering by status gives unexpected results:
If you filter for statuses of 'revising', you will never see any manuscripts, since first-version manuscripts never have this status.
Or, as another example, if a manuscript's title is changed in a subsequent version, then it may not appear in alphabetical order when sorting by title.
This was observed on Hack4Impact's branch, but the bug predates their work.