ACSD-67093: GraphQL date range filter returns incorrect orders results

Categories

GraphQL, Order/Checkout

Components

magento/module-sales-graph-ql

Origin

adobe-commerce-support

Since QPT

1.1.70

Issue

GraphQL date range filter returns incorrect orders results.

Steps to reproduce

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).

Adobe's page lists 2.4.8 - 2.4.8-p2 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 ACSD-67093. On Cloud, add ACSD-67093 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-67093/ 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

Sources

• Adobe documentation for ACSD-67093
• JSON API: /api/v1/patches/ACSD-67093