{"data":{"id":"ACP2E-4239","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue where Admin grid filters using date attributes return incorrect results due to timezone differences between the selected date, stored UTC values, and the configured store timezone.","categories":["Admin"],"components":["magento/module-catalog","magento/module-cms","magento/module-customer","magento/module-sales","magento/module-ui"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-80/acp2e-4239","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-80/acp2e-4239.md","blobSha":"07bc7dd94495f2df66c724e0e7f38a9bd1849676","description":"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.","stepsToReproduce":"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.","introducedInQpt":"1.1.80","createdFor":["2.4.7-p8","2.4.8-p2"],"documentedRange":"2.4.7 - 2.4.8-p5","scheduledFixRelease":"2.4.9"},"files":[{"package":"magento/magento2-base","constraint":">=2.4.7 <2.4.8","path":"patches/os/ACP2E-4444_2.4.7-p8.patch","blobSha":"717d5e8980284fd5d34b14bfce89aa4c3849610b","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/ACP2E-4444_2.4.7-p8.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-catalog/Ui/Component/Listing/Columns.php","change":"modified","package":"magento/module-catalog"},{"path":"vendor/magento/module-cms/Model/ResourceModel/Block/Grid/Collection.php","change":"modified","package":"magento/module-cms"},{"path":"vendor/magento/module-cms/Model/ResourceModel/Page/Grid/Collection.php","change":"modified","package":"magento/module-cms"},{"path":"vendor/magento/module-customer/Model/ResourceModel/Grid/Collection.php","change":"modified","package":"magento/module-customer"},{"path":"vendor/magento/module-sales/Model/ResourceModel/Order/Grid/Collection.php","change":"modified","package":"magento/module-sales"},{"path":"vendor/magento/module-sales/Plugin/Model/ResourceModel/Order/OrderGridCollectionFilter.php","change":"deleted","package":"magento/module-sales"},{"path":"vendor/magento/module-sales/etc/adminhtml/di.xml","change":"modified","package":"magento/module-sales"},{"path":"vendor/magento/module-ui/Component/Filters.php","change":"modified","package":"magento/module-ui"},{"path":"vendor/magento/module-ui/Component/Filters/Type/Date.php","change":"modified","package":"magento/module-ui"},{"path":"vendor/magento/module-ui/Component/Form/Element/DataType/Date.php","change":"modified","package":"magento/module-ui"}],"packages":["magento/module-catalog","magento/module-cms","magento/module-customer","magento/module-sales","magento/module-ui"],"hasTests":false,"applicableVersions":{"magento-community":["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"],"magento-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"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false},{"package":"magento/magento2-base","constraint":">=2.4.8 <2.4.9","path":"patches/os/ACSD-68244_2.4.8-p2.patch","blobSha":"927c6e03a109273b18af2c8169347660d056b834","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/ACSD-68244_2.4.8-p2.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-catalog/Ui/Component/Listing/Columns.php","change":"modified","package":"magento/module-catalog"},{"path":"vendor/magento/module-cms/Model/ResourceModel/Block/Grid/Collection.php","change":"modified","package":"magento/module-cms"},{"path":"vendor/magento/module-cms/Model/ResourceModel/Page/Grid/Collection.php","change":"modified","package":"magento/module-cms"},{"path":"vendor/magento/module-customer/Model/ResourceModel/Grid/Collection.php","change":"modified","package":"magento/module-customer"},{"path":"vendor/magento/module-sales/Model/ResourceModel/Order/Grid/Collection.php","change":"modified","package":"magento/module-sales"},{"path":"vendor/magento/module-sales/Plugin/Model/ResourceModel/Order/OrderGridCollectionFilter.php","change":"deleted","package":"magento/module-sales"},{"path":"vendor/magento/module-sales/etc/adminhtml/di.xml","change":"modified","package":"magento/module-sales"},{"path":"vendor/magento/module-ui/Component/Filters.php","change":"modified","package":"magento/module-ui"},{"path":"vendor/magento/module-ui/Component/Filters/Type/Date.php","change":"modified","package":"magento/module-ui"},{"path":"vendor/magento/module-ui/Component/Form/Element/DataType/Date.php","change":"modified","package":"magento/module-ui"}],"packages":["magento/module-catalog","magento/module-cms","magento/module-customer","magento/module-sales","magento/module-ui"],"hasTests":false,"applicableVersions":{"magento-community":["2.4.8-p5","2.4.8-p4","2.4.8-p3","2.4.8-p2","2.4.8-p1","2.4.8"],"magento-commerce":["2.4.8-p5","2.4.8-p4","2.4.8-p3","2.4.8-p2","2.4.8-p1","2.4.8"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":["2.4.8-p5","2.4.8-p4","2.4.8-p3","2.4.8-p2","2.4.8-p1","2.4.8","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"],"magento-commerce":["2.4.8-p5","2.4.8-p4","2.4.8-p3","2.4.8-p2","2.4.8-p1","2.4.8","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"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACP2E-4239 details"}