1. About > News
2. Open the select menu for Languages
3. Examine the list of languages in the menu
4. Look at a post with languages listed as Translations
Languages in the menu and on translated posts are currently sorted alphabetically by their short name, which means the list contains such seemingly inexplicable alphabetization as "Suomi" (fi) coming between "español" (es) and "Français" (fr).
Much like we did with fandom tags, we want to add a sortable_name column to the languages table so admins can set an optional name to use for alphabetization. If no name is set, it should continue to fall back to the abbreviation (short_name).
That process should go like:
1. Log in as admin
2. Go to languages page at http://test.ao3.org/languages
3. Choose "Edit" for a language, e.g. Suomi
4. Enter an optional name to sort on (e.g. Suomi) in a text field labeled "Name for alphabetical sorting"
5. Update Language
6. Voila ! Suomi is now with the other S-languages on the Language menu and in the list of translations on any news post that uses it
We want to do this via a new sortable_name column rather than using the languages' actual names to avoid having all the languages that begin with non-Latin characters ending up in a jumble at the end.
Please note that languages from http://test.ao3.org/languages are used in many places throughout the site. In addition to the admin post pages referred to above, here is a list of places that should be updated to use the sortable_name:
http://test.ao3.org/works/search - work search page
http://test.ao3.org/works/new - new work page (2 places: "Choose a language" dropdown in Associations section, and check "This work is a remix, a translation, a podfic, or was inspired by another work" option for a separate Language dropdown)
http://test.archiveofourown.org/users/USERNAME/works/edit_multiple - edit multiple works page
http://test.ao3.org/tags/TAGNAME/works - filters for works listing
http://test.ao3.org/tags/TAGNAME/bookmarks - filters for bookmarks listing
http://test.ao3.org/admin_posts/new - admin post form (needs admin access)
https://test.ao3.org/languages - language list
Note: the following 2 locations are currently sorting by language name right now. This means that this fix will appear to "break" the alphabetical sorting on these pages until an admin adds sortable_names to the relevant languages.
https://test.archiveofourown.org/abuse_reports/new - new abuse report
https://test.archiveofourown.org/support - new support request