{"data":{"id":"ACSD-59036","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes an exception that happens when loading product prices with both lower and upper bound equal to $0.","categories":["Catalog Search"],"components":["magento/module-elasticsearch"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-50/acsd-59036-exception-occurs-when-loading-product-prices","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-50/acsd-59036-exception-occurs-when-loading-product-prices.md","blobSha":"d000de31e207704b5eeea9e5ac8372d672316ab2","description":"An exception occurs when loading product prices with both lower and upper bounds set to $0. The issue is occurring because the algorithm does not account for NULL values when loading the query with price ranges. To fix this, we can check if both the lower and upper ranges are NULL, and if they are, assign a value of 0 for both limits. This should prevent any errors from being thrown.","stepsToReproduce":"1. Create 13 simple products. 1. Assign all 13 products to a category. 1. Set the price of one product to $1322.94. 1. Set the price of all other products to $0. 1. Configure OpenSearch as a search engine. 1. Go to Stores > Configuration > Catalog > Storefront and set the PLP count to 16. 1. Set Price Navigation Step Calculation to Automatic (equalize product counts). 1. Run full reindex. 1. Open the Category page.","introducedInQpt":"1.1.50","createdFor":["2.4.7"],"documentedRange":"2.4.7 - 2.4.7-p2","scheduledFixRelease":"2.4.8"},"files":[{"package":"magento/magento2-base","constraint":">=2.4.7 <2.4.8","path":"patches/os/ACSD-59036_2.4.7.patch","blobSha":"9ec9c15aeb18721703d8b617405b84ef156d35e2","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/ACSD-59036_2.4.7.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-elasticsearch/ElasticAdapter/SearchAdapter/Aggregation/Interval.php","change":"modified","package":"magento/module-elasticsearch"}],"packages":["magento/module-elasticsearch"],"hasTests":false,"applicableVersions":{"magento-community":["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"],"magento-commerce":["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"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":["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"],"magento-commerce":["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"],"mage-os":[]},"conditions":{"or":[{"type":"log","path":"var/log/exception.log","match":"report.CRITICAL: OpenSearch\\Common\\Exceptions\\BadRequest400Exception: * [bool] failed to parse field"},{"type":"log","path":"var/log/support_report.log","match":"[bool] failed to parse field [filter]"}]},"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACSD-59036 details"}