sql

How to insert multiple records into a table without a model?

Hello folks, welcome back to my blog. In this article, I give you a sample code to insert multiple records into a table. Normally we use the repository, resource model to save records. But it will be good for a single record. If we have bulk data and save data with foreach it will become…

Continue Reading How to insert multiple records into a table without a model?

How to use multiple AND and OR conditions in searchCriteria filter in Magento 2?

In this article, I will show you how you can use multiple OR and AND operation in searchCriteria filter. When we are working with API and working with getList collection using searchCriteria, we sometimes need to build a custom query to get the collection. There are two main part of searchCrieria FilterFilter Group 1. Filter…

Continue Reading How to use multiple AND and OR conditions in searchCriteria filter in Magento 2?