Add Sorting Capability for finished_at and failed_at Fields

[hatsu38]

Feature Request: Sorting by finished_at and failed_at fields

It would be very useful if the mission_control-jobs gem could support sorting jobs not only by their jobed times but also by other relevant timestamps such as finished_at and failed_at.

Example Use Cases:

This would be particularly handy when you want to view jobs that have recently failed.

[film42]

To be honest, I was a little confused when I opened the failed queue and found it sorted oldest to newest. I would prefer the failed queue to follow the finish queue, showing newest jobs first.

Here's my expereince:

I was expecting an email to be delivered but it didn't happen. I checked the finished queue and found no matching jobs around the time it should have finished. I checked the failed queue and saw "21 days ago" and thought, "maybe solidqueue dropped it?" Only then did I see they were ordered oldest to newest, and I had to click 5-6 pages in to see the most recent failed job.

[ibrahima]

I agree, I was hoping for a change like #210 to make it easier to get to the recent jobs, but I also feel like changing the default order should be much easier and IMO shouldn't be controversial. Making it sortable would also be great but that's a bigger UI change. It would be consistent with the "Finished Jobs" tab as well. Hmm... might be worth submitting a PR just to change to see if it would be accepted.

[hatsu38]

I also found the default sorting by oldest first confusing — I definitely see value in changing it to show the most recent jobs first. I’ll try creating a pull request to sort them in descending order by default!