{"data":{"id":"MDVA-38447","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes two issues; where the 'Not visible individually' configurable child products are returned in GraphQL response and optimize MySQL query for GraphQL products query with category filter.","categories":["Performance","GraphQL"],"components":["magento/module-catalog-graph-ql"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-2/mdva-38447-not-visible-individually-configurable-child-products","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-2/mdva-38447-not-visible-individually-configurable-child-products.md","blobSha":"6f9275ef80e4c0c61a9960a68cf88e25bae8131d","description":"\"Not visible individually\" configurable child products are returned in GraphQL response and slow MySQL query for GraphQL products query with category filter.","stepsToReproduce":"1. Create a configurable product with simple products set to Not visible individually. 1. Run a full reindex. 1. Run a GraphQL query like: <pre>query getFilteredProducts( $filter: ProductAttributeFilterInput! $sort: ProductAttributeSortInput! $search: String $pageSize: Int! $currentPage: Int! ) { products( filter: $filter sort: $sort search: $search pageSize: $pageSize currentPage: $currentPage ) { total_count page_info { total_pages current_page page_size } items { name sku } } }</pre> Variables: <pre>{\"filter\":{\"user_group\":{\"eq\":\"\"}},\"search\":\"config-100\",\"sort\":{},\"pageSize\":200,\"currentPage\":1} </pre>","introducedInQpt":"1.1.2","createdFor":["2.4.2"],"documentedRange":"2.4.2 - 2.4.3","scheduledFixRelease":"2.4.4"},"files":[{"package":"magento/magento2-base","constraint":">=2.4.2 <2.4.4","path":"patches/os/MDVA-38447_2.4.2.patch","blobSha":"309f5960d6edf06d6ae33aea57e3ad495b5cf1cb","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/MDVA-38447_2.4.2.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-catalog-graph-ql/Model/Resolver/Products/DataProvider/ProductSearch.php","change":"modified","package":"magento/module-catalog-graph-ql"},{"path":"vendor/magento/module-catalog-graph-ql/Model/Resolver/Products/SearchCriteria/CollectionProcessor/FilterProcessor/CategoryFilter.php","change":"modified","package":"magento/module-catalog-graph-ql"}],"packages":["magento/module-catalog-graph-ql"],"hasTests":false,"applicableVersions":{"magento-community":["2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2"],"magento-commerce":["2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":["2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2"],"magento-commerce":["2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch MDVA-38447 details"}