QUALITY PATCH

ACSD-65750: The GraphQL "route" query doesn't return products in the correct sort order…

The GraphQL "route" query doesn't return products in the correct sort order when using the Page Builder Products content type. Quality patch ACSD-65750 for magento/module-page-builder applies to Magento Open Source and Adobe Commerce 2.4.7 to 2.4.8-p5.

Categories
Content, GraphQL
Components
magento/module-page-builder
Origin
adobe-commerce-support
Since QPT
1.1.66

Issue

The GraphQL "route" query doesn't return products in the correct sort order when using the Page Builder Products content type.

Steps to reproduce

1. Create a new category and some products in Catalog, and link the products to this category. 1. Navigate to Catalog > Categories, edit the created category, and open the Products in Category tab. 1. Set custom Position for each product in this category. 1. Save the category and run reindex. 1. Navigate to Content > Elements > Pages and click Add New Page. 1. Expand the Content tab, then click Edit with Page Builder. 1. Drag a Row element into the content area, then drag a Products element inside the row. 1. Configure the Products element as follows: * Select Products By: Category * Category: Select the newly created category * Sort By: Position 1. Switch to the Search Engine Optimization tab, and set the URL Key to test-widget. 1. Save the page. 1. Make the following GraphQL request: query { route(url: "/test-widget") { relative_url redirect_code type ... on CmsPage { identifier content __typename } ... on ProductInterface { uid __typename } ... on CategoryInterface { uid __typename } __typename } }

Adobe's page lists 2.4.7-p1 - 2.4.8 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-65750. On Cloud, add ACSD-65750 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-65750/ 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 (1): magento/module-page-builder
Packages across compatible versions (1): magento/module-page-builder

magento/module-page-builder >=2.2.5 <2.2.7

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, 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.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
Patch file
patches/os/ACSD-65750_2.2.5-p4.patch
  • vendor/magento/module-page-builder/etc/graphql/di.xml

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.