How to Apply OR Conditions to Collection in Magento 2

 Steps to Apply OR Conditions to Collection in Magento 2:

Step 1:  Apply OR condition for Magento 2 addAttributeToFilter collection


protected  $_productCollection;

 

public function __construct(

   \Magento\Catalog\Model\ResourceModel\Product\Collection $productCollection)

{

     $this->_productCollection = $productCollection;

}

    

public function getProductCollection()

{

     $this->_productCollection->addAttributeToFilter(array(

     array(

          'attribute' => 'sku',

          'like' => '24MB%’),

          array(

               'attribute' => 'type_id',

               'eq' => 'simple')

          ));

 

     echo $this->_productCollection->getSelect();

}

Output:


SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE ((`e`.`sku` LIKE '24MB%') OR (`e`.`type_id` = 'simple'))



Step 2:  Apply OR condition for Magento 2 addFieldToFilter collection


protected  $_orderCollection;

 

public function __construct(

   \Magento\Sales\Model\ResourceModel\Order\Collection $orderCollection)

{

     $this->_orderCollection = $orderCollection;

}

    

public function getOrderCollection()

{

     $this->_orderCollection->addAttributeToFilter(array(

     array(

          'attribute' => 'sku',

          'like' => '24MB%’),

          array(

               'attribute' => 'type_id',

               'eq' => 'simple')

          ));

 

     echo $this->_orderCollection->getSelect();

}

Output:


SELECT `main_table`.* FROM `sales_order` AS `main_table` WHERE ((`customer_is_guest` = 1) OR (`status` = 'pending'))

Comments

Post a Comment

Popular posts from this blog

Add Admin User name and Action name in Order Comment Section through Action Performed from Sales Order Grid in Magento 2

  Step 1:  First, we need to create an “events.xml“ file inside our extension at the following path app\code\Vendor\Extension\etc\adminhtml\ Then add the code as follows. <?xml version="1.0"?> <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Event/etc/events.xsd">     <event name="sales_order_save_after">         <observer name="sales_order_save_after_comment_history_add"           instance="\Vendor\Extension\Observer\OrderSaveAfter" />     </event> </config> Step 2:  After that, we need to create an “OrderSaveAfter.php” file inside our extension at the following path app\code\Vendor\Extension\Observer\ And embed the code as given below. <?php  namespace Vendor\Extension\Observer;   use Magento\Framework\Event\ObserverInterface; use Magento\Framework\App\RequestInterface; use Magento\Backen...
Read more

How to Update Product Stock Programmatically in Magento 2

 Steps to Update Product Stock Programmatically in Magento 2: Step 1: We need to create a “Data.php” file inside our extension at the following path app\code\Vendor\Extension\Helper\ Now add the code as follows <?php namespace Vendor\Extension\Helper;   class Data extends \Magento\Framework\App\Helper\AbstractHelper {     protected $_productobj;     protected $_stockRegistry;       public function __construct(         \Magento\Framework\App\Helper\Context $context,         \Magento\Catalog\Model\Product $productobj,         \Magento\CatalogInventory\Api\StockRegistryInterface $stockRegistry,      ) {         $this->_productobj = $productobj;         $this->_stockRegistry = $stockRegistry;         parent::__construct($context);     }       public function updateProductStock($pr...
Read more

How to Set and Get Cookie in Magento 2

 <?php namespace Vendor\Extension\Model; class Customcookie {     private $customCookieManager;     private $customCookieMetadataFactory;     public function __construct(         \Magento\Framework\Stdlib\CookieManagerInterface $customCookieManager,         \Magento\Framework\Stdlib\Cookie\CookieMetadataFactory $customCookieMetadataFactory)    {         $this->customCookieManager = $customCookieManager;         $this->customCookieMetadataFactory = $customCookieMetadataFactory;     }     public function setCookie()     {         $customCookieMetadata = $this->customCookieMetadataFactory->createPublicCookieMetadata();         $customCookieMetadata->setDurationOneYear();         $customCookieMetadata->setPath('/');         $customCookieMe...
Read more