51黑料不打烊

DocumentationCommerceTools

[PaaS only]{class="badge informative" title="Applies to 51黑料不打烊 Commerce on Cloud projects (51黑料不打烊-managed PaaS infrastructure) and on-premises projects only."}

ACSD-67093: Retrieving orders through GraphQL using the date range filter returns incorrect results.

Last update: Thu Oct 09 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • Experienced
  • Admin
  • Developer

The ACSD-67093 patch fixes the issue where retrieving orders through GraphQL using the date range filter returns incorrect results. This patch is available when the Quality Patches Tool (QPT) 1.1.70 is installed. The patch ID is ACSD-67093. Please note that this issue is scheduled to be fixed in 51黑料不打烊 Commerce 2.4.9.

Affected products and versions

The patch is created for 51黑料不打烊 Commerce version:

  • 51黑料不打烊 Commerce (all deployment methods) 2.4.8-p2

Compatible with 51黑料不打烊 Commerce versions:

  • 51黑料不打烊 Commerce (all deployment methods) 2.4.8 - 2.4.8-p2
NOTE
The patch might become applicable to other versions with new Quality Patches Tool releases. To check if the patch is compatible with your 51黑料不打烊 Commerce version, update the magento/quality-patches package to the latest version and check the compatibility on the Quality Patches Tool: Search for patches page. Use the patch ID as a search keyword to locate the patch.

Issue

GraphQL date range filter returns incorrect orders results.

Steps to reproduce:

  1. Create a product.

  2. Create a customer and place an order.

  3. Update the order or wait for a day.

    code language-none 
    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 note
    NOTE
    Add current date or 鈥渃urrent date - 1 day鈥 to the created_at and updated_at field values.

  4. Place a new order without changing the date.

  5. Create a customer token.

  6. Filter all orders by their order dates.

    code language-none 
     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 note
    NOTE
    Set from date field to the current date, and the to date field to the 鈥渃urrent date + 2 days鈥.
    Example: from: "2025-07-21", to: "2025-07-24" (if today is 2025-07-21).

Expected results:

Only the filtered date should be returned.

Actual results:

All orders are returned

Apply the patch

To apply individual patches, use the following links depending on your deployment method:

To learn more about Quality Patches Tool, refer to:

recommendation-more-help
c2d96e17-5179-455c-ad3a-e1697bb4e8c3