Make duration on "List Dag Run" sortable

[alejandrofm]

Description

Currently, all elements of that view are sortable, it would be nice to have the ability to sort it.
Location: dagrun/list/

Use case/motivation

An easy solution to have a quick view of the longest/shortest duration task for a particular filter.

Related issues

No response

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[alejandrofm]

I would try to submit a PR if you guide me a little.

[pierrejeambrun]

Hello @alejandrofm,

Just assigned you :)

You can start looking at the file airflow/www/views.py, the class DagRunModelView.

Duration is not a db column, so it cannot be treated in the same way as other columns.

One way to achieve this would be to add a column_property/hybrid_property (preferably hybrid) to the model so it is reconstructed at query time. Then from the application point of view, it would just behave like any other columns.

Maybe others will have a better way of achieving this.

Note: For task instance we also persist to the db the duration. (on top of start_date and end_date not sure why, it seems a bit redundant, but we could do something similar as well)

[bbovenzi]

Something we can still add for the dag run tables in AF3

[valentinDruzhinin]

@eladkal @alejandrofm is this issue still open? I would like to implement it

[pierrejeambrun]

Hello @valentinDruzhinin, yes this is still relevant, I just assigned you :)