How to use Group By and Having Clause SQL query in magento 2?

Magento Group By SQL query used to fetch the same set of values from a specified column. While We use group by clause with aggregate function

We must have to use the Having clause and where clause is not used with Group By Aggregrate functions. Continue reading “How to use Group By and Having Clause SQL query in magento 2?”

How to fixed GraphQl response The account sign-in was incorrect or your account is disabled temporarily in Magento?

Magento has added new features called GraphQl from the Magento 2.3 version.

While working with Magento GraphQl feature for the generating customer token, you might be facing the error, Continue reading “How to fixed GraphQl response The account sign-in was incorrect or your account is disabled temporarily in Magento?”

How to use left join SQL query in Model class Magento 2?

Magento 2 Left Join SQL query in resource model class to get data from multiple tables.

Left Join is used to fetch all records from the left table and retrieve matching records from the second table.

We can use joinLeft() method to use Left Join in Magento Collection.

A Demo to fetch customers with customer address details like city and postcode from the customer_address_entity table using the join query. Continue reading “How to use left join SQL query in Model class Magento 2?”