josix commented on issue #42720: URL: https://github.com/apache/airflow/issues/42720#issuecomment-2419173701
After investigation, I found that SQLAlchemy fails to execute this query because `value_1` is being passed as a string type when query_count is called in [SQLInterface.query](https://github.com/dpgaspar/Flask-AppBuilder/blob/master/flask_appbuilder/models/sqla/interface.py#L489). (which is the datamodel of XComModelView inherits from and also the interface to retrieve the XComs from db). Since I'm not very familiar with FAB, I'm still working on finding a way to pass the value as a non-string type. Any suggestions would be appreciated. ``` SELECT xcom.dag_run_id AS xcom_dag_run_id, xcom.task_id AS xcom_task_id, xcom.map_index AS xcom_map_index, xcom.key AS xcom_key, xcom.dag_id AS xcom_dag_id, xcom.run_id AS xcom_run_id, xcom.value AS xcom_value, xcom.timestamp AS xcom_timestamp, dag_run_1.state AS dag_run_1_state, dag_run_1.id AS dag_run_1_id, dag_run_1.dag_id AS dag_run_1_dag_id, dag_run_1.queued_at AS dag_run_1_queued_at, dag_run_1.execution_date AS dag_run_1_execution_date, dag_run_1.start_date AS dag_run_1_start_date, dag_run_1.end_date AS dag_run_1_end_date, dag_run_1.run_id AS dag_run_1_run_id, dag_run_1.creating_job_id AS dag_run_1_creating_job_id, dag_run_1.external_trigger AS dag_run_1_external_trigger, dag_run_1.run_type AS dag_run_1_run_type, dag_run_1.conf AS dag_run_1_conf, dag_run_1.data_interval_start AS dag_run_1_data_interval_start, dag_run_1.data_interval_end AS dag_run_1_data_interval_end, dag_run_1.last_scheduling_decision AS dag_run_1_last_scheduling_decision, dag_run_1.dag_hash AS dag_run_1_dag_hash, dag_run_1.log_template_id AS dag_run_1_log_template_id, dag_run_1.updated_at AS dag_run_1_updated_at, dag_run_1.clear_number AS dag_run_1_clear_number FROM xcom LEFT OUTER JOIN dag_run AS dag_run_1 ON xcom.dag_run_id = dag_run_1.id WHERE xcom.value ILIKE %(value_1) s ``` -- 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]
