Skip to main content

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']))

        ->addAttributeToFilter('store_year', array('finset' => $params['store_year']))

        ->addAttributeToFilter('status', array('eq' => \Magento\Catalog\Model\Product\Attribute\Source\Status::STATUS_ENABLED))

        ->setFlag('has_stock_status_filter', false)

        ->joinField('stock_item', 'cataloginventory_stock_item', 'is_in_stock', 'product_id=entity_id', 'is_in_stock=1')

        ->addCategoriesFilter(array('eq' => 296));


same like mysql if you have one value find in array of data you will FIND_IN_SET like here we use finset

SELECT * FROM `catalog_product_entity_varchar` WHERE FIND_IN_SET(5680,value) AND entity_id = 29162 AND attribute_id=183

if this post useful pls comment 

Thank you

Labels:

Comments

  1. Nathan Duference28 September 2020 at 22:38

    Thank you for sharing such useful information. I really enjoyed while reading your article and it is good to know the latest updates. Do post more. And also read about Magento 2 Development Company

    ReplyDelete
  2. Zinavo-Web Design | Web Development | SEO | Mobile Apps | ERP/CRM24 October 2020 at 06:10

    It is amazing and wonderful to visit your Blog.Thanks for sharing this information,this is useful to me. Website Design Company in Bangalore | Top Web Design Company in Bangalore | Website Designing Companies in Bangalore

    ReplyDelete
  3. Digital Blogger27 October 2020 at 04:49

    Nice Article. Useful information you have provided. Keep it up for your tech blog success. Also Read Magneto 2.4 features

    ReplyDelete
  4. Tecocraft5 November 2020 at 03:53

    Thanks for the sharing this amazing info. Read my blog in Why Magento is the Best eCommerce Platform for Enterprise.

    ReplyDelete
  5. Tecocraft8 March 2021 at 22:15

    Upgrade from Magento1 to Magento 2 for your website, read on to find the key differences between the two versions and then decide. Find out the differences between Magento 1 vs Magento 2.

    ReplyDelete
  6. Tecocraft11 May 2021 at 05:44

    This comment has been removed by the author.

    ReplyDelete

Post a Comment

Popular posts from this blog

Integrity constraint violation: 1052 Column 'created_at' in where clause is ambiguous

When trying to filter sales order grid with From and To dates it was redirecting to dashboard.after that again i tried to open sales order grind it is generating reports in reports file it showing. "Integrity constraint violation: 1052 Column 'created_at' in where clause is ambiguous" means it is finding a another created_at field. because when we adding or joining the other table then it has also a field named as created_at. So below is the  solution for this error. magento that created_at is of the main_table not of my custom table. Find the below code in the sales order grid.php file. $this->addColumn('created_at', array(            'header' => Mage::helper('sales')->__('Purchased On'),             'index' => 'created_at',             'type' => 'datetime',             'width' => '100px',         )); just replace the code with below one.  $this
Post a Comment
Read more

How to Add Magento 2 Sort by Price for Low to High & High to Low Options and name A-Z & Z-A etc sort dropdown

The store design and its navigation must be in such a way that makes it easier for the shopper to find the exact required product and make the shopping process comfortable and enjoyable.  Navigation can be made easier and hence improve the shopping experience by offering custom sorting options. The default Magento 2 offers sorting by position, product name, and price  A price-sensitive customer may save some clicks by starting with the cheapest products. On the other hand, customers who have a high standard for quality may quickly find their most desired products by sampling from high prices to low prices. To provide such feature in Magento 2 and serve both the type of price-sensitive customers, you can add Magento 2 sort by price for low to high & high to low options. Some people can sort by names A-Z or Z-A, position low to high high to low like this we can improve sales to our site and user can easily find products for implementing this fallow given steps to implement sorting Ad
Post a Comment
Read more