QUALITY PATCH

ACSD-58108: The missing join table name in the original fetching table causes SQL errors in the order…

The missing join table name in the original fetching table causes SQL errors in the order grid when using a custom module extension. Quality patch ACSD-58108 for magento/module-sales applies to Magento Open Source and Adobe Commerce 2.4.6 to 2.4.7-p10.

Categories: Order/Checkout, Admin
Components: magento/module-sales
Origin: adobe-commerce-support
Since QPT: 1.1.69

Issue

The missing join table name in the original fetching table causes SQL errors in the order grid when using a custom module extension. This issue occurs because the addFilterToMap function does not work for certain columns after joining the sales_order_item table, resulting in errors while filtering.

Steps to reproduce

01. Install a 2.4-develop instance. 02. Create a new order. 03. Install a custom module with an SQL extension. 04. Navigate to Admin > Sales > Orders. 05. Apply the Purchase Date filter and wait for the result. 06. Apply Product SKU filter.

Adobe's page lists 2.4.6 - 2.4.7-p6 as compatible; the versions below are resolved from the current QPT constraints and are the ones the tool will offer.

Adobe scheduled the permanent fix for 2.5.0.

Install

Install the Quality Patches Tool with composer require magento/quality-patches, apply the prerequisites listed for all files applicable to your distribution and version first, then run vendor/bin/magento-patches apply ACSD-58108. On Cloud, add ACSD-58108 under stage.build.QUALITY_PATCHES in .magento.env.yaml.

For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its ACSD-58108/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Bundle prerequisites the same way and list them first. Paths are relative to each package root, using the default -p1 level. Prefer local files when configuring composer-patches; a remote URL can change.