Joins In Magento 2

In this article we will learn magento2 mysql join queries. The Syntax of Join is $query = $salesRelatedProducts->getSelect() ->join( [‘rpt’ => ‘sales_related_products_list’], ‘main_table.sales_id = rpt.sales_id’ )->where(“main_table.sales_id = 3”); echo $query->__toString(); …

Read More

Create UI Grid in Magento 2

Today we will learn how to create magento 2 admin grid with ui- component <?xml version=”1.0″ encoding=”UTF-8″?> <listing xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xsi:noNamespaceSchemaLocation=”urn:magento:module:Magento_Ui:etc/ui_configuration.xsd”> <argument name=”data” xsi:type=”array”> <item name=”js_config” xsi:type=”array”> <item name=”provider” xsi:type=”string”>flash_sales_pro_listing.flash_sales_pro_listing_data_source</item> <item …

Read More