Tag: Magento 2

Posted on

How to apply OR conditions to searchCriteria filter 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?”

Posted on

How to apply OR conditions to collection in Magento 2?

In Magento 2, You can apply OR conditions on collection. By default, When you work with collection, Your conditions will be AND.

AND Condition
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'));

Output:
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?”

Posted on

Get list of Layout XML called for a current page Magento 2.

You can get a list of called Layout XML for specific pages by Magento\Framework\App\View class.

Call getLayout() method from Magento\Framework\App\View.php class.

getLayout()->getUpdate()->getHandles() used for getting all the handles of a page.

You need to keep below code at the end of root index.php file to check the available layout XML files for a page. Continue reading “Get list of Layout XML called for a current page Magento 2.”