{"data":{"id":"ACSD-67093","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue where retrieving orders through GraphQL using the date range filter returns incorrect results.","categories":["GraphQL","Order/Checkout"],"components":["magento/module-sales-graph-ql"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-71/acsd-67093","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-71/acsd-67093.md","blobSha":"7ce35abcda0fb5aaffe9fa8c0d73f8ff58aa5960","description":"GraphQL date range filter returns incorrect orders results.","stepsToReproduce":"1. Create a product. 1. Create a customer and place an order. 1. Update the order or wait for a day. UPDATE sales_order SET created_at = '2025-07-01 12:00:00', updated_at = '2025-07-01 12:00:00' WHERE entity_id = 1; UPDATE sales_order_grid SET created_at = '2025-07-01 12:00:00', updated_at = '2025-07-01 12:00:00' WHERE entity_id = 1; >[!NOTE] > >Add current date or \"current date - 1 day\" to the created_at and updated_at field values. 1. Place a new order without changing the date. 1. Create a customer token. 1. Filter all orders by their order dates. query{ customer{ orders(pageSize: 10, currentPage: 1, filter: { order_date: { from: \"2025-07-21\", to: \"2025-07-24\" } }) { items { order_number created_at status grand_total }, total_count } } } >[!NOTE] > Set from date field to the current date, and the to date field to the \"current date + 2 days\". > > Example: from: \"2025-07-21\", to: \"2025-07-24\" (if today is 2025-07-21).","introducedInQpt":"1.1.70","createdFor":["2.4.8-p2"],"documentedRange":"2.4.8 - 2.4.8-p2","scheduledFixRelease":"2.4.9"},"files":[{"package":"magento/magento2-base","constraint":">=2.4.8 <2.4.9","path":"patches/os/ACSD-67093_2.4.8-p2.patch","blobSha":"1de63df662f42471a2a838ff4f173c10469c6636","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/ACSD-67093_2.4.8-p2.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-sales-graph-ql/Model/Resolver/CustomerOrders/Query/OrderFilter.php","change":"modified","package":"magento/module-sales-graph-ql"}],"packages":["magento/module-sales-graph-ql"],"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"],"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":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACSD-67093 details"}