MDVA-30186: Unsorted attribute options in GraphQL response

The MDVA-30186 patch solves the issue where attribute options are not sorted in the GraphQL response. This patch is available when the Quality Patches Tool (QPT) 1.0.23 is installed. The patch ID is MDVA-30186. Please note that the issue was fixed in Adobe Commerce 2.4.3.

Affected products and versions

The patch is created for Adobe Commerce version:

  • Adobe Commerce on cloud infrastructure 2.3.4 and 2.4.2

Compatible with Adobe Commerce versions:

  • Adobe Commerce (all deployment methods) 2.3.4 - 2.3.5-p2, 2.4.0 - 2.4.0-p1, and 2.4.2 - 2.4.2-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

Steps to reproduce:

  1. Add any three options to the existing color attribute.

  2. Create six simple products with options (Example: Option 1: 1 product, Option 2: 2 products, Option 3: 3 products).

  3. Create a category and assign all the products created above.

  4. Now make the following GraphQL request with your category id:

    
 {
   products(
     filter: { category_id: { eq: "3" } }
     pageSize: 200
     currentPage: 1
     sort: { name: ASC }
   ) {
     aggregations {
       attribute_code
       count
       label
       options {
         count
         label
         value
       }
     }
     items {
       name
       sku
       url_key
     }
   }
 }

  5. Now alter the sort order of attribute options from the attribute edit page in the Admin.

  6. Make the above GraphQL request again, and observe the color attribute options.

Expected results:

The attribute options are sorted according to the order set from the Admin.

Actual results:

The attribute options are always sorted according to the associated number of products.

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.

On this page