UI: Allow sorting workflows by more criteria

[rbreeze]

Summary

Allow for users to sort the UI workflow list by duration, name (alphabetically), and finish time.

Motivation

I wanted to quickly find a workflow with a long duration in the UI, but realized there was no way to sort them.

Proposal

For the UI, something as simple as an up/down arrow on each column's header that a user can click to sort by that column. The color of the active column's header could be different to indicate which sorting criteria is currently selected.

---

Message from the maintainers:

If you wish to see this enhancement implemented please add a 👍 reaction to this issue! We often sort issues this way to know what to prioritize.

[herebebeasties]

I would also love to be able to sort cron workflows by "next run", so you can easily see upcoming runs and when they will be.

[agilgur5]

Was just discussing sorting on Slack and wanted to jot down some notes here.

Currently, sorting is pretty limited due to the k8s API and etcd -- see #4546 (comment), #3565 (comment), #2926, which all link to kubernetes/kubernetes#80602.

#12736 should allow for lots more sorting options to be performed efficiently.

[agilgur5]

@Adrien-D this one is also now possible if you'll be doing more work on the list

[Adrien-D]

@agilgur5 I'll keep in mind but I won't have time for this at the moment

[daturkel]

Not being able to sort workflows by time started or completed makes debugging pretty painful for our team: it's not easy to find recently started or recently failed jobs.

I see that #2926 has been closed as resolved but this issue is still open. Is there any work ongoing on this? Is it blocked?

[agilgur5]

Is it blocked?

Per my above comment, this issue was blocked on upstream k8s/etcd, but with the new SQLite DB cache it can now be implemented through that instead.

Is there any work ongoing on this?

PR welcome. If anyone were working on it, it would be in the thread already.

It looks like you also asked about this on Slack