{"data":{"id":"MDVA-31321","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes a blank page (error) when \"Show All\" is selected. Elasticsearch returns large list of product ids. In this scenario the order by clause gets converted to an incorrect SQL format.","categories":["Catalog Search"],"components":["magento/module-elasticsearch"],"origin":"adobe-commerce-support","documentation":null,"files":[{"package":"magento/magento2-base","constraint":">=2.3.2 <2.3.3 || 2.3.3-p1","path":"patches/os/MDVA-31321_2.3.2.patch","blobSha":"64d967985a5537cd0e611e16511d705d55b226f8","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/MDVA-31321_2.3.2.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-elasticsearch/Model/ResourceModel/Fulltext/Collection/SearchResultApplier.php","change":"modified","package":"magento/module-elasticsearch"}],"packages":["magento/module-elasticsearch"],"hasTests":false,"applicableVersions":{"magento-community":["2.3.2-p2","2.3.2-p1","2.3.2"],"magento-commerce":["2.3.2-p2","2.3.2-p1","2.3.2"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false},{"package":"magento/magento2-base","constraint":"2.3.3","path":"patches/os/MDVA-31321_2.3.3.patch","blobSha":"58e61d3bcbdeb6bdf32e70e87ebc04ed613f2593","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/MDVA-31321_2.3.3.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-elasticsearch/Model/ResourceModel/Fulltext/Collection/SearchResultApplier.php","change":"modified","package":"magento/module-elasticsearch"}],"packages":["magento/module-elasticsearch"],"hasTests":false,"applicableVersions":{"magento-community":["2.3.3"],"magento-commerce":["2.3.3"],"mage-os":[]},"unknownVersions":[],"requires":["MAGECLOUD-4847"],"replacedWith":null,"deprecated":false},{"package":"magento/magento2-base","constraint":">=2.3.4 <2.3.5","path":"patches/os/MDVA-29968_2.3.4-p2.patch","blobSha":"63424b0e12c9a9174406ad34002ac6da1dda8d77","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/MDVA-29968_2.3.4-p2.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-elasticsearch/Model/ResourceModel/Fulltext/Collection/SearchResultApplier.php","change":"modified","package":"magento/module-elasticsearch"}],"packages":["magento/module-elasticsearch"],"hasTests":false,"applicableVersions":{"magento-community":["2.3.4-p2","2.3.4-p1","2.3.4"],"magento-commerce":["2.3.4-p2","2.3.4-p1","2.3.4"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":["2.3.4-p2","2.3.4-p1","2.3.4","2.3.3","2.3.2-p2","2.3.2-p1","2.3.2"],"magento-commerce":["2.3.4-p2","2.3.4-p1","2.3.4","2.3.3","2.3.2-p2","2.3.2-p1","2.3.2"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch MDVA-31321 details"}