moathOSA opened a new issue #19271: URL: https://github.com/apache/superset/issues/19271
 this is the generated query in the dashboard and as you see there is some filters applied twice like Currency * i tried every thing like using the filter name instead of the field name * i tried to make field name diff from the filter name making alias for the fields name .... nothing work ! this is the query with filters ``` SELECT `orders`.`cancelled` AS `Cancelled`,`orders`.`confirmed` AS `Confirmed`, `orders`.`visible` AS `Visible`, `orders`.`created_at` AS `Created_at`, `orders`.`order_no` AS `Order_No`, `orders`.`amount` AS `Amount`, `orders`.`currency` AS `Currency`, `orders`.`normalized_amount_usd` AS `Normalized_Amount_Usd`, `stores__via__branch_id`.`domain` AS `Branch_Domain`, `orders`.`shipment_type` AS `Shipment_Type`,`Stores`.`deal_growth` AS `Deal_Growth` ,`Stores`.`domain` AS `Stores_Domain`, `Stores`.`template` AS `Stores_Template`, `Stores`.`stage` AS `Stores_Stage`, `Stores`.`country` AS `Stores_Country`, `Stores`.`city` AS `Stores_City` FROM `orders` LEFT JOIN `stores` `Stores` ON `orders`.`store_id` = `Stores`.`id` LEFT JOIN `stores` `stores__via__branch_id` ON `orders`.`branch_id` = `stores__via__branch_id`.`id` WHERE 'Amount' != 'dumy condition' {% if from_dttm != None %} AND orders.Created_at >= '{{ from_dttm }}' AND orders.Created_at < '{{ to_dttm }}' {% endif %} {%- if (filter_values('Domain') is defined) and filter_values('Domain') -%} AND Stores_Domain IN ({{ "'" + "','".join(filter_values('Domain')) + "'" }}) {%- endif -%} {%- if (filter_values('Country') is defined) and filter_values('Country') -%} AND Stores_Country IN ({{ "'" + "','".join(filter_values('Country')) + "'" }}) {%- endif -%} {%- if (filter_values('Currency') is defined) and filter_values('Currency') -%} AND Currency IN ({{ "'" + "','".join(filter_values('Currency')) + "'" }}) {%- endif -%} {%- if (filter_values('Shipment Type') is defined) and filter_values('Shipment Type') -%} AND orders.Shipment_Type IN ({{ "'" + "','".join(filter_values('Shipment Type')) + "'" }}) {%- endif -%} {%- if (filter_values('Deal Growth') is defined) and filter_values('Deal Growth') -%} AND Deal_Growth IN ({{ "'" + "','".join(filter_values('Deal Growth')) + "'" }}) {%- endif -%} ``` ************* superset version 1.4.1 i don't see any similar problem to this problem -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
