MDVA-40120: GraphQL product DESC/ASC sort doesn’t work

The MDVA-40120 patch solves the issue where GraphQL sorting by DESC/ASC doesn’t work with products having the same relevance or price. This patch is available when the Quality Patches Tool (QPT) 1.1.6 is installed. The patch ID is MDVA-40120. Please note that the issue is scheduled to be fixed in Adobe Commerce 2.4.4.

Affected products and versions

The patch is created for Adobe Commerce version:

  • Adobe Commerce (all deployment methods) 2.4.2-p1

Compatible with Adobe Commerce versions:

  • Adobe Commerce (all deployment methods) 2.4.1 - 2.4.3-p1
NOTE
The patch might become applicable to other versions with new Quality Patches Tool releases. To check if the patch is compatible with your Adobe 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

Prerequisites:

Create a few different products with the same price.

Steps to reproduce:

  1. Run the following GraphQL query:

    code language-graphql
    
     {
       products(filter: {category_id: {eq: "{{cat_id}}"}}, sort: {relevance: ASC}) {
         total_count
         items {
           name
           sku
         }
       }
     }
    
    
  2. Check the response.

  3. Change the sort order from ASC to DESC in the GraphQL query:

    code language-graphql
    
     {
       products(filter: {category_id: {eq: "{{cat_id}}"}}, sort: {relevance: DESC}) {
         total_count
         items {
           name
           sku
         }
       }
     }
    
    
  4. Check the response.

Expected results:

The product listing in the GraphQL response should be changed according to the sort order.

Actual results:

The sort order remains unchanged.

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:

For info about other patches available in QPT, refer to Patches available in QPT in our developer documentation.

recommendation-more-help
8bd06ef0-b3d5-4137-b74e-d7b00485808a