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

What startSetup() and endSetup() methods actually does?

The startSetup() and endSetup() methods are used in setup scripts. They are often at the beginning and the end of an upgrade/install method, like in “upgrade()” method of Magento/Catalog/Setup/UpgradeData.php The question is “do you really need them?” Or does it just “look necessary”? This blog post explores what these functions do and then explains when you do and do not need to use these methods. Let’s see what these methods are doing. First, startSetup(): public function startSetup() {   $this->rawQuery("SET SQL_MODE=''");  $this->rawQuery("SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0");   $this->rawQuery("SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'");   return $this;  } 1. Disable foreign keys check. It may be necessary in some rare cases (for example, in a case of cyclic references between tables), but it’s not needed in common situations. It even may lead to hiding real problems...
Post a Comment
Read more

Magento 2 UI Component Grid Explanation

1) layout file inside Company/Module/view/adminhtml/layout/routerid_controller_action.xml define grid as uiComponent with: 2) uiComponent is defined in Company/Module/view/adminhtml/ui_component/listing_name.xml file. File name must be the same as uiComponent name used in layout file. The structure of the file may seem pretty complex at first sight but as always these are some repeating nodes. To make it simple lets slice it. Main node of the component file is <listing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:module:Magento_Ui:etc/ui_configuration.xsd">. It is fixed and I believe it requires namespace location attribute. Next there are typically 4 nodes inside <listing /> node: <argument />, <dataSource />, <container /> and <columns />. This is however not a strict setup as <argument /> node might be duplicated to provide more configuration or <container /> as...
6 comments
Read more