Skip to main content

Magetno 2 get the products collection filter by attributes with or condition

how to get product collection with filters? I'm use magento 2 . So i'm trying to get in product collection with filter multiple attributes with or condition for custom search

use below product collection object if your wring any blocks if not use object manager and create product collection object

use Magento\Catalog\Model\ResourceModel\Product\CollectionFactory as ProductCollection;


$productcollection = $objectManager->create('Magento\Catalog\Model\ResourceModel\Product\Collection');


$collection = $this->_productCollection
                                    ->create()
                                    ->addFieldToSelect('*')
                                    ->addAttributeToFilter(
                                    array(
                                            array('attribute' => 'name', array('like' => '%'.$queryString.'%')),
                                            array('attribute' => 'oem_no',array('like' => '%' .$queryString.'%')),
                                            array('attribute' => 'oem_brand',array('like' => '%' .$queryString.'%'))
                                        )
                            );

this above code gives or condition with result.

$collection = $this->_productCollection
                 ->create()
                 ->addFieldToSelect('*')
                 ->addFieldToFilter('name', ['like' => '%'.$queryString.'%'])->addFieldToFilter('product_title', ['like' => '%'.$queryString.'%']);

this code gives filter and operation


Labels:

Comments

Post a Comment

Popular posts from this blog

Magento 2 product collection Filtering multi-select attribute values

  If you have multi-select attribute of product like below If you want filter value for this option Use below syntax to get product data: ->addAttributeToFilter('store_model', array('finset' => $params['store_model'])) finset key is used for multiselect attribute filter. $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); $products = $objectManager->get('Magento\Catalog\Model\Product')         ->getCollection()         ->addAttributeToSelect('*')         ->addAttributeToSelect('store_brand')         ->addAttributeToSelect('store_model')         ->addAttributeToSelect('store_year')         ->addAttributeToFilter('store_brand', array('finset' => $params['store_brand']))         ->addAttributeToFilter('store_model', array('finset' => $params['store_model']))         ->ad...
6 comments
Read more

magento 2 best seller product display based on current category and subcategories

Magento 2 getting best seller based on category wise displaying i have done below for that to implement this functionality it is working fine for me. step 1 create block file in our module folder <?php namespace Pawan\Bestseller\Block; use Magento\Catalog\Api\CategoryRepositoryInterface; class Bestsellercategory extends \Magento\Catalog\Block\Product\ListProduct {     /**      * Product collection model      *      * @var Magento\Catalog\Model\Resource\Product\Collection      */     protected $_collection;     /**      * Product collection model      *      * @var Magento\Catalog\Model\Resource\Product\Collection      */     protected $_productCollection;     /**      * Image helper      *      * @var Magento\Catalog\Helper\Image     ...
6 comments
Read more

order cancel from front end

if you want cancel order from front end create module like this app/etc/modules/<Namespace_Modulename>.xml <config>     <modules>         <Namespace_CustomerOrderCancel>             <active>true</active>             <codePool>community</codePool>             <depends>                 <Mage_Sales />             </depends>         </ Namespace _CustomerOrderCancel>     </modules> </config> app/community/Namespace/Modulename           ------controllers           -------etc           -------Helper if you want cancel button in history page (myorder) need override block file Mage_Sales_Block_Orde...
2 comments
Read more