You have to copy the vendor\magento\module-catalog\ Ui\DataProvider\Product\ProductCollection.php
to
app/code/Magento/Catalog/Ui/ DataProvider/Product/ ProductCollection.php
Replace the following code in addAttributeToFilterAllStores(Attribute $attributeModel, array $condition): void function
$condition = "({$pKey} = {$fKey}) AND ("
. $this->_getConditionSql("{$tableName}.value", $condition)
. ')';
With
$attributeId = $attributeModel->getAttributeId();
$condition = "({$pKey} = {$fKey}) AND ("
. $this->_getConditionSql("{$tableName}.value", $condition)
. ') AND ('
. $this->_getConditionSql("{$tableName}.attribute_id", $attributeId)
. ')';
to
app/code/Magento/Catalog/Ui/
Replace the following code in addAttributeToFilterAllStores(Attribute $attributeModel, array $condition): void function
$condition = "({$pKey} = {$fKey}) AND ("
. $this->_getConditionSql("{$tableName}.value", $condition)
. ')';
With
$attributeId = $attributeModel->getAttributeId();
$condition = "({$pKey} = {$fKey}) AND ("
. $this->_getConditionSql("{$tableName}.value", $condition)
. ') AND ('
. $this->_getConditionSql("{$tableName}.attribute_id", $attributeId)
. ')';
No comments:
Post a Comment
Thanks for your comments.