Filtering on date does not work because of ambigous field names #40024
Description
Preconditions and environment
- Magento version : 2.4.7-p6
When filtering the order grid on date an error occurs.
This is because of the introduction of certain Braintree modules in the last patch version.
The query that is generated :
SELECT main_table.*, braintree_transaction_details.transaction_source, sales_order.dispute_statusFROMsales_order_gridASmain_tableLEFT JOINbraintree_transaction_detailsON braintree_transaction_details.order_id = main_table.entity_id LEFT JOINsales_order ON sales_order.entity_id = main_table.entity_id WHERE (((created_at >= '2025-06-01 22:00:00'))) AND (((created_at<= '2025-06-26 21:59:59'))) ORDER BY main_table.created_at DESC
paypal/module-braintree is required by magento/product-community-edition so cannot be removed
Steps to reproduce
Open admin
Go to order grid
try to filter using a date
Expected result
Filtered order list with orders matching the set filters
Actual result
An error message
Additional information
No response
Release note
No response
Triage and priority
- Severity: S0 - Affects critical data or functionality and leaves users without workaround.
- Severity: S1 - Affects critical data or functionality and forces users to employ a workaround.
- Severity: S2 - Affects non-critical data or functionality and forces users to employ a workaround.
- Severity: S3 - Affects non-critical data or functionality and does not force users to employ a workaround.
- Severity: S4 - Affects aesthetics, professional look and feel, “quality” or “usability”.