Would it be possible for us to order the pages listing Members-Only and WIP submissions by the date of the last action taken on them (creation, revision, comment, etc.) by the author? By pushing pages with the most recent actions to the top, it would greatly improve quality-of-life for the Editors who focus on reviewing submissions, as it would allow us to more easily see which pages the authors genuinely want reviewed, and which ones are just sitting on the site doing nothing (much of the stuff from 2022 and prior, and especially from 2021 and prior, does this).
My gut feeling is that it shouldn't be too hard, but I am not yet fluent enough in SQL to do this by myself yet.
@Fergus:
Would it be possible for us to order the pages listing Members-Only and WIP submissions by the date of the last action taken on them (creation, revision, comment, etc.) by the author? By pushing pages with the most recent actions to the top, it would greatly improve quality-of-life for the Editors who focus on reviewing submissions, as it would allow us to more easily see which pages the authors genuinely want reviewed, and which ones are just sitting on the site doing nothing (much of the stuff from 2022 and prior, and especially from 2021 and prior, does this).
My gut feeling is that it shouldn't be too hard, but I am not yet fluent enough in SQL to do this by myself yet.