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
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
ReplyDeleteIt 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
ReplyDeleteNice Article. Useful information you have provided. Keep it up for your tech blog success. Also Read Magneto 2.4 features
ReplyDeleteThanks for the sharing this amazing info. Read my blog in Why Magento is the Best eCommerce Platform for Enterprise.
ReplyDeleteUpgrade 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.
ReplyDeleteThis comment has been removed by the author.
ReplyDelete