How to get product custom options list by GraphQl query?

Magento GraphQl query to fetch product custom options list using CustomizableOptionInterface.

The Customizable Option Interface contains basic information about a product’s customizable options.

You can create different types of Custom Options for the product like text field, text area, radio button, dropdown, multi-select, image, file uploading, etc… Continue reading “How to get product custom options list by GraphQl query?”

How to fixed GraphQl Fields conflicting types. Use different aliases on the fields to fetch result?

GraphQl aliases are used to prevent errors of GraphQL fields conflict type in the response of the query.

Using Aliases in the query to fix the issue of the conflicting type of GraphQl while same type of  arguments are used in a query.

Let’s say a real example to understand these aliases. Continue reading “How to fixed GraphQl Fields conflicting types. Use different aliases on the fields to fetch result?”

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