You can apply custom conditions to Product Collection before load by creating a plugin in Magento 2. Some situation in your project need to add some conditions before product collection loaded you can achieve it by below way,
In Magento\Catalog\Model\ResourceModel\Product\Collection file load() method is used for load the product collection globally.
Continue reading “How to apply custom condition before product collection loaded magento 2?”
Third Party Platform interact with Magento 2 by API. When you are working for API related stuff and using SearchCriteriaBuilder Object for your query and if you want to apply OR conditions for custom query, You need to define setFilterGroups([Object]) for OR query.
Whenever you are dealing with SearchCriteriaBuilder in Magento 2, You might be need to query with OR conditions for custom requirement, You can give OR conditions to Magento\Framework\Api\SearchCriteriaBuilder by simple code snippets.
Let’s imagine, We built a query using OR conditions for Products. Continue reading “How to apply OR conditions to searchCriteria filter Magento 2?”
In Magento 2, You can apply OR conditions on collection. By default, When you work with collection, Your conditions will be AND.
Fetch collection of only those products whose sku is like `24MB%` AND `type_id` is equal to simple.
$collection = $this->productCollectionFactory->create();
$collection->addAttributeToFilter('sku', array('like' => '24MB%'));
$collection->addAttributeToFilter('type_id', array('eq' => 'simple'));
SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (`e`.`sku` LIKE ’24MB%’) AND (`e`.`type_id` = ‘simple’); Continue reading “How to apply OR conditions to collection in Magento 2?”