{"data":{"id":"ACSD-48059","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue with Visual Merchandiser where merchants cannot save the \"Match product by rule\" for the Categories attribute.","categories":["Catalog/Product"],"components":["magento/module-visual-merchandiser"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-27/acsd-48059-merchants-cannot-save-the-match-product-by-rule-for-categories-attribute","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-27/acsd-48059-merchants-cannot-save-the-match-product-by-rule-for-categories-attribute.md","blobSha":"9213fe8611237391815ba8baaa60e101e376a003","description":"Merchants cannot save the Match product by rule for categories attribute in Visual Merchandiser.","stepsToReproduce":"1. Go to Stores > Configuration > Catalog > Visual Merchandiser > Visible Attributes for Category Rules, add categories. 1. Go to the Adobe Commerce Admin > Catalog > Categories. * Go to the Products in Category section. * Add a new Match products by rule condition with the categories attribute.","introducedInQpt":"1.1.27","createdFor":["2.4.5"],"documentedRange":"2.3.7 <2.4.7","scheduledFixRelease":"2.4.7"},"files":[{"package":"magento/magento2-ee-base","constraint":">=2.3.7 <2.4.7","path":"patches/commerce/ACSD-48059_2.4.5.patch","blobSha":"d4be17b0af20f626056e209d48f674f4ddd0f5ee","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/commerce/ACSD-48059_2.4.5.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-visual-merchandiser/Model/Rules.php","change":"modified","package":"magento/module-visual-merchandiser"},{"path":"vendor/magento/module-visual-merchandiser/Model/Rules/Rule/CategoryId.php","change":"modified","package":"magento/module-visual-merchandiser"},{"path":"vendor/magento/module-visual-merchandiser/etc/di.xml","change":"modified","package":"magento/module-visual-merchandiser"},{"path":"vendor/magento/module-visual-merchandiser/i18n/en_US.csv","change":"modified","package":"magento/module-visual-merchandiser"},{"path":"vendor/magento/module-visual-merchandiser/view/adminhtml/web/js/merchandiser.js","change":"modified","package":"magento/module-visual-merchandiser"}],"packages":["magento/module-visual-merchandiser"],"hasTests":false,"applicableVersions":{"magento-community":[],"magento-commerce":["2.4.6-p15","2.4.6-p14","2.4.6-p13","2.4.6-p12","2.4.6-p11","2.4.6-p10","2.4.6-p9","2.4.6-p8","2.4.6-p7","2.4.6-p6","2.4.6-p5","2.4.6-p4","2.4.6-p3","2.4.6-p2","2.4.6-p1","2.4.6","2.4.5-p17","2.4.5-p16","2.4.5-p15","2.4.5-p14","2.4.5-p13","2.4.5-p12","2.4.5-p11","2.4.5-p10","2.4.5-p9","2.4.5-p8","2.4.5-p7","2.4.5-p6","2.4.5-p5","2.4.5-p4","2.4.5-p3","2.4.5-p2","2.4.5-p1","2.4.5","2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4","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","2.4.1-p1","2.4.1","2.4.0-p1","2.4.0","2.3.7-p4","2.3.7-p3","2.3.7-p2","2.3.7-p1","2.3.7"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":[],"magento-commerce":["2.4.6-p15","2.4.6-p14","2.4.6-p13","2.4.6-p12","2.4.6-p11","2.4.6-p10","2.4.6-p9","2.4.6-p8","2.4.6-p7","2.4.6-p6","2.4.6-p5","2.4.6-p4","2.4.6-p3","2.4.6-p2","2.4.6-p1","2.4.6","2.4.5-p17","2.4.5-p16","2.4.5-p15","2.4.5-p14","2.4.5-p13","2.4.5-p12","2.4.5-p11","2.4.5-p10","2.4.5-p9","2.4.5-p8","2.4.5-p7","2.4.5-p6","2.4.5-p5","2.4.5-p4","2.4.5-p3","2.4.5-p2","2.4.5-p1","2.4.5","2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4","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","2.4.1-p1","2.4.1","2.4.0-p1","2.4.0","2.3.7-p4","2.3.7-p3","2.3.7-p2","2.3.7-p1","2.3.7"],"mage-os":[]},"conditions":{"and":[{"type":"log","path":"var/log/support_report.log","match":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.category_ids' in 'where clause', query was: SELECT `e`.`entity_id` FROM `catalog_product_entity` AS"}]},"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACSD-48059 details"}