Sorting of `tests.files` and related tables by `tournament` or `events` does not alphabetically sort

scioly / scioly.org

Scioly.org server files for public contributions

6 stars 0 forks source link

Sorting of `tests.files` and related tables by `tournament` or `events` does not alphabetically sort #26

Closed georgemsun closed 4 years ago

georgemsun commented 4 years ago

Sorting of tests.files and related tables by tournament or events does not alphabetically sort because it is sorting the numbers and not the text. Should link the two tables so that the sorted value is the actual text value.

georgemsun commented 4 years ago

This has been fixed by inner joining the tests.tournaments and tests.events table on search and sorting by the new columns tournament_name and event_name.