fredym opened a new issue, #25557:
URL: https://github.com/apache/airflow/issues/25557
### Apache Airflow version
2.3.3
### What happened
When I pull a list of Task Instances sorted by Logical Date (execution_date)
using this URL:
```
https://<host>/<deployment>/airflow/taskinstance/list/?_oc_TaskInstanceModelView=dag_run.execution_date&_od_TaskInstanceModelView=desc&_flt_3_state=failed&_flt_1_execution_date=2022-08-04+00%3A00%3A00%2B00%3A00
```
...I get this SQL error message:
```
psycopg2.errors.UndefinedTable: invalid reference to FROM-clause entry for
table "dag_run"
LINE 5: ...022-08-04T00:00:00+00:00'::timestamptz)) ORDER BY dag_run.ex...
^
HINT: Perhaps you meant to reference the table alias "dag_run_1".
```
### What you think should happen instead
I'm expecting a list of Task Instances filtered by the specified parameters
but I'm getting a SQL error message instead.
Based on the error message, I presume the OMR layer is generating a
malformed SQL statement. I would try updating that library as it seems like an
underlying bug.
### How to reproduce
Open this URL in the browser you usually use to access Airflow UI: (replace
<host> and <deployment> with yours)
```
https://<host>/<deployment>/airflow/taskinstance/list/?_oc_TaskInstanceModelView=dag_run.execution_date&_od_TaskInstanceModelView=desc&_flt_3_state=failed&_flt_1_execution_date=2022-08-04+00%3A00%3A00%2B00%3A00
```
### Operating System
Debian GNU/Linux 11 (bullseye)
### Versions of Apache Airflow Providers
_No response_
### Deployment
Astronomer
### Deployment details
_No response_
### Anything else
This happens every time I try to open the URL mentioned above.
### Are you willing to submit PR?
- [X] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of
Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
