Magento 2 Product Collection: addAttributeToFilter with LIKE Operator Not Working

collection;magento2product-collection

Could anyone help me why the following code returns empty result when use LIKE operator with addAttributeToFilter option? Thanks!

$productcollection = $this->_objectManager->create('Magento\Catalog\Model\ResourceModel\Product\Collection')
       ->addAttributeToSelect(['name', 'price', 'image'])
       ->addAttributeToFilter('name', array('LIKE' => '%Iphone%'))
       ->setPageSize(10,1);

Best Answer

Use 'like' instead of 'LIKE'

$productcollection = $this->_objectManager->create('Magento\Catalog\Model\ResourceModel\Product\Collection')
                                                  ->addAttributeToSelect(['name', 'price', 'image'])
                                                  ->addAttributeToFilter('name', array('like' => '%Iphone%'))
                                                  ->setPageSize(10,1);

You can print query following way:

echo $productcollection->getSelect()->__toString();

Related Solutions

Magento 1.8 – Fix addAttributeToFilter Not Filtering on Product Collection

Try like this

$selections_products = $modelCatalogProduct->getCollection()
->setPageSize(32)
->addAttributeToSelect(array('name','selection_moment','selection_rouge','selection_blanc','selection_cdc','selection_champagne','selection_exception'))
->addAttributeToFilter(
    array(
        array('attribute'=>'selection_moment', 'eq' => '1'),
        array('attribute'=>'selection_rouge', 'eq' => '1'),
        array('attribute'=>'selection_blanc', 'eq' => '1'),
        array('attribute'=>'selection_cdc', 'eq' => '1'),
        array('attribute'=>'selection_champagne', 'eq' => '1'),
        array('attribute'=>'selection_exception', 'eq' => '1')
    )
);

Refer this link

Magento – Having pagination issue with collection with addAttributeToFilter

I, too, am having the very same issue - filtering works perfectly fine, but no matter where I perform the filtering, the LayeredNavigation will not work correctly.

Whilst I can't "comment", hopefully this "partial answer" can help you along?

By moving the filtering into a CollectionFilter, pagination works fine for me.

My di.xml:

<preference for="Magento\Catalog\Model\Layer\Category\CollectionFilter" type="Company\Plugin\Model\Layer\Category\CollectionFilter"/>

The CollectionFilter:

public function filter($collection, \Magento\Catalog\Model\Category $category) {
        $collection
            ->addAttributeToSelect($this->catalogConfig->getProductAttributes())
            ->addMinimalPrice()
            ->addFinalPrice()
            ->addTaxPercents()
            ->addUrlRewrite($category->getId())
            ->setVisibility($this->productVisibility->getVisibleInCatalogIds());

            $filterBy = {custom code in here}

            $collection->addAttributeToFilter('supplier_code', array('IN' => $filterBy));

    }

I am just not sure if the LayeredNavigation is working correctly, or filtering must be performed earlier in the execution chain.

Can anyone else shed some light on this?

Best Answer

Related Solutions

Magento 1.8 – Fix addAttributeToFilter Not Filtering on Product Collection

Magento – Having pagination issue with collection with addAttributeToFilter

Related Topic