QUALITY PATCH

ACP2E-4239: Admin grid filters that use date attributes return no results…

Admin grid filters that use date attributes return no results because of a timezone mismatch between the selected date, stored UTC values, and the configured store timezone. Quality patch ACP2E-4239 for magento/module-catalog applies to Magento Open Source and Adobe Commerce 2.4.7 to 2.4.8-p5.

Categories
Admin
Components
magento/module-catalog, magento/module-cms, magento/module-customer, magento/module-sales, magento/module-ui
Origin
adobe-commerce-support
Since QPT
1.1.80

Issue

Admin grid filters that use date attributes return no results because of a timezone mismatch between the selected date, stored UTC values, and the configured store timezone.

Steps to reproduce

1. Place an order. 1. Create an invoice for the order. 1. Create a credit memo. 1. Go to Admin > Sales > Credit Memos. 1. Click Filter and select the current date in the Created from and Created to fields. 1. Click Filter.

Adobe's page lists 2.4.7 - 2.4.8-p5 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.4.9.

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 ACP2E-4239. On Cloud, add ACP2E-4239 under stage.build.QUALITY_PATCHES in .magento.env.yaml.

For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its ACP2E-4239/ 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.

Patch files and compatible versions

Packages across compatible versions (5): magento/module-catalog, magento/module-cms, magento/module-customer, magento/module-sales, magento/module-ui
Packages across compatible versions (5): magento/module-catalog, magento/module-cms, magento/module-customer, magento/module-sales, magento/module-ui

magento/magento2-base >=2.4.7 <2.4.8

Magento Open Source
2.4.7-p10, 2.4.7-p9, 2.4.7-p8, 2.4.7-p7, 2.4.7-p6, 2.4.7-p5, 2.4.7-p4, 2.4.7-p3, 2.4.7-p2, 2.4.7-p1, 2.4.7
Adobe Commerce
2.4.7-p10, 2.4.7-p9, 2.4.7-p8, 2.4.7-p7, 2.4.7-p6, 2.4.7-p5, 2.4.7-p4, 2.4.7-p3, 2.4.7-p2, 2.4.7-p1, 2.4.7
Patch file
patches/os/ACP2E-4444_2.4.7-p8.patch
  • vendor/magento/module-catalog/Ui/Component/Listing/Columns.php
  • vendor/magento/module-cms/Model/ResourceModel/Block/Grid/Collection.php
  • vendor/magento/module-cms/Model/ResourceModel/Page/Grid/Collection.php
  • vendor/magento/module-customer/Model/ResourceModel/Grid/Collection.php
  • vendor/magento/module-sales/Model/ResourceModel/Order/Grid/Collection.php
  • vendor/magento/module-sales/Plugin/Model/ResourceModel/Order/OrderGridCollectionFilter.php (deleted)
  • vendor/magento/module-sales/etc/adminhtml/di.xml
  • vendor/magento/module-ui/Component/Filters.php
  • vendor/magento/module-ui/Component/Filters/Type/Date.php
  • vendor/magento/module-ui/Component/Form/Element/DataType/Date.php

magento/magento2-base >=2.4.8 <2.4.9

Magento Open Source
2.4.8-p5, 2.4.8-p4, 2.4.8-p3, 2.4.8-p2, 2.4.8-p1, 2.4.8
Adobe Commerce
2.4.8-p5, 2.4.8-p4, 2.4.8-p3, 2.4.8-p2, 2.4.8-p1, 2.4.8
Patch file
patches/os/ACSD-68244_2.4.8-p2.patch
  • vendor/magento/module-catalog/Ui/Component/Listing/Columns.php
  • vendor/magento/module-cms/Model/ResourceModel/Block/Grid/Collection.php
  • vendor/magento/module-cms/Model/ResourceModel/Page/Grid/Collection.php
  • vendor/magento/module-customer/Model/ResourceModel/Grid/Collection.php
  • vendor/magento/module-sales/Model/ResourceModel/Order/Grid/Collection.php
  • vendor/magento/module-sales/Plugin/Model/ResourceModel/Order/OrderGridCollectionFilter.php (deleted)
  • vendor/magento/module-sales/etc/adminhtml/di.xml
  • vendor/magento/module-ui/Component/Filters.php
  • vendor/magento/module-ui/Component/Filters/Type/Date.php
  • vendor/magento/module-ui/Component/Form/Element/DataType/Date.php

Sources

Łukasz Bajsarowicz
Built by

Łukasz Bajsarowicz, e-commerce architect

Magento and Adobe Commerce architecture, upgrades, performance and audits for merchants and agencies since 2015; magento.watch is the tooling I use on those projects.

Open source, maintained on weekends.