Extension attributes are particularly useful when you want to associate additional information with these entities without altering the database schema. <\/p>\n\n\n\n
They enable smoother upgrades and compatibility with other extensions. Developers define extension attributes in the XML configuration, providing a flexible way to enhance data models without compromising the integrity of the core system.<\/p>\n\n\n\n
Extension attribute joins in Magento developers<\/a> allow to efficiently retrieve additional data from related tables when querying entities like products<\/em> or orders<\/em>. <\/p>\n\n\n\n This enhances data retrieval and customization capabilities without modifying the core database structure.<\/p>\n\n\n\n Also you have check our Magento 2 Order attributes<\/a>\u00a0extension.<\/p>\n\n\n\n To join extension attributes in Magento 2, follow these steps:<\/strong><\/p>\n\n\n\n Step 1:- Define Extension Attribute<\/strong><\/p>\n\n\n\n Create your extension attribute using XML in your module’s Step 2:- Create db_schema.xml at app\/code\/Webkul\/ExtentionAttribute\/etc<\/strong><\/p>\n\n\n\n Step 3:- Create webapi.xml at app\/code\/Webkul\/ExtentionAttribute\/etc<\/strong><\/p>\n\n\n\n Step 4:- Create di.xml at app\/code\/Webkul\/ExtentionAttribute\/etc<\/strong><\/p>\n\n\n\n Step 5:- Create OrderManagementInterface.php at app\/code\/Webkul\/ExtentionAttribute\/Api<\/strong><\/p>\n\n\n\n Step 6:-Create OrderManagement.php at app\/code\/Webkul\/ExtentionAttribute\/Model<\/strong><\/p>\n\n\n\n Step 7:- Load Extension Attribute Data After the join,<\/strong><\/p>\n\n\n\n However, in case of any query or questions regarding the Magento 2 Extensions<\/a>, you can create a ticket at webkul.uvdesk.com<\/a> or contact us at store.webkul.com\/contacts\/<\/a> to let us know your views to make the plugin better.<\/p>\n\n\n\n Hope this will help you.<\/p>\n\n\n\n Thanks \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"etc\/extension_attributes.xml<\/strong><\/code> file. Specify the entity you want to extend (e.g., product, order)<\/strong> and define the attribute structure.<\/p>\n\n\n\n<?xml version="1.0"?>\n<!--\n\/**\n * Webkul Software.\n *\n * @category Webkul\n * @package Webkul_ExtentionAttribute\n * @author Webkul Software Private Limited\n * @copyright Webkul Software Private Limited (https:\/\/webkul.com)\n * @license https:\/\/store.webkul.com\/license.html\n *\/\n-->\n<config xmlns:xsi="http:\/\/www.w3.org\/2001\/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Api\/etc\/extension_attributes.xsd">\n <extension_attributes for="Magento\\Sales\\Api\\Data\\OrderInterface">\n <attribute code="custom_col1" type="string">\n <join reference_table="custom_table" join_on_field="entity_id" reference_field="order_id">\n <field column="custom_col1">custom_col1<\/field>\n <\/join>\n <\/attribute>\n <attribute code="custom_col2" type="string">\n <join reference_table="custom_table" join_on_field="entity_id" reference_field="order_id">\n <field column="custom_col2">custom_col1<\/field>\n <\/join>\n <\/attribute>\n <\/extension_attributes>\n<\/config><\/pre>\n\n\n\n
<?xml version="1.0"?>\n<!--\n\/**\n * Webkul Software.\n *\n * @category Webkul\n * @package Webkul_ExtentionAttribute\n * @author Webkul Software Private Limited\n * @copyright Webkul Software Private Limited (https:\/\/webkul.com)\n * @license https:\/\/store.webkul.com\/license.html\n *\/\n-->\n<schema xmlns:xsi="http:\/\/www.w3.org\/2001\/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Setup\/Declaration\/Schema\/etc\/schema.xsd">\n <table name="custom_table" engine="innodb">\n <column xsi:type="int" name="order_id" padding="10" unsigned="true" nullable="false"\/>\n <column xsi:type="varchar" name="custom_col1" nullable="false" default="First"\/>\n <column xsi:type="varchar" name="custom_col2" nullable="false" default="Second"\/>\n <constraint xsi:type="primary" referenceId="PRIMARY">\n <column name="order_id"\/>\n <\/constraint>\n <constraint xsi:type="foreign" referenceId="CUSTOM_TABLE_ORDER_ID_SALES_ORDER_ENTITY_ID"\n table="custom_table" column="order_id" referenceTable="sales_order"\n referenceColumn="entity_id" onDelete="CASCADE"\/>\n <\/table>\n<\/schema><\/pre>\n\n\n\n
<?xml version="1.0" ?>\n<!--\n\/**\n * Webkul Software.\n *\n * @category Webkul\n * @package Webkul_ExtentionAttribute\n * @author Webkul Software Private Limited\n * @copyright Webkul Software Private Limited (https:\/\/webkul.com)\n * @license https:\/\/store.webkul.com\/license.html\n *\/\n-->\n<routes xmlns:xsi="http:\/\/www.w3.org\/2001\/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:module:Magento_Webapi:etc\/webapi.xsd">\n\t<route method="GET" url="\/V1\/getOrderList">\n\t\t<service class="Webkul\\ExtentionAttribute\\Api\\OrderManagementInterface" method="getList"\/>\n\t\t<resources>\n\t\t\t<resource ref="anonymous"\/>\n\t\t<\/resources>\n\t<\/route>\n<\/routes><\/pre>\n\n\n\n
<?xml version="1.0" ?>\n<!--\n\/**\n * Webkul Software.\n *\n * @category Webkul\n * @package Webkul_ExtentionAttribute\n * @author Webkul Software Private Limited\n * @copyright Webkul Software Private Limited (https:\/\/webkul.com)\n * @license https:\/\/store.webkul.com\/license.html\n *\/\n-->\n<config xmlns:xsi="http:\/\/www.w3.org\/2001\/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager\/etc\/config.xsd">\n <preference for="Webkul\\ExtentionAttribute\\Api\\OrderManagementInterface" type="Webkul\\ExtentionAttribute\\Model\\OrderManagement"\/>\n<\/config><\/pre>\n\n\n\n
<?php\n\/**\n * Webkul Software.\n *\n * @category Webkul\n * @package Webkul_ExtentionAttribute\n * @author Webkul Software Private Limited\n * @copyright Webkul Software Private Limited (https:\/\/webkul.com)\n * @license https:\/\/store.webkul.com\/license.html\n *\/\n\nnamespace Webkul\\ExtentionAttribute\\Api;\n \ninterface OrderManagementInterface {\n\n \/**\n * Get order List\n * \n * @return array\n *\/\n public function getList();\n}<\/pre>\n\n\n\n<?php\n\/**\n * Webkul Software.\n *\n * @category Webkul\n * @package Webkul_ExtentionAttribute\n * @author Webkul Software Private Limited\n * @copyright Webkul Software Private Limited (https:\/\/webkul.com)\n * @license https:\/\/store.webkul.com\/license.html\n *\/\n\nnamespace Webkul\\ExtentionAttribute\\Model;\n \nclass OrderManagement {\n \n \/**\n * Construct function\n *\n * @param \\Magento\\Sales\\Api\\OrderRepositoryInterface $repository\n * @param \\Magento\\Framework\\Api\\SearchCriteriaInterface $searchCriteria\n * @param \\Magento\\Framework\\Api\\Search\\FilterGroup $filterGroup\n * @param \\Magento\\Framework\\Api\\Filter $filter\n *\/\n public function __construct(\n \\Magento\\Sales\\Api\\OrderRepositoryInterface $repository,\n \\Magento\\Framework\\Api\\SearchCriteriaInterface $searchCriteria,\n \\Magento\\Framework\\Api\\Search\\FilterGroup $filterGroup,\n \\Magento\\Framework\\Api\\Filter $filter\n ) {\n $this->repository = $repository;\n $this->searchCriteria = $searchCriteria;\n $this->filterGroup = $filterGroup;\n $this->filter = $filter;\n }\n\n \/**\n * @inheritdoc\n *\/\n public function getList()\n {\n $returnArr = [];\n $repository = $this->repository;\n $searchCriteria = $this->searchCriteria;\n $filterGroup = $this->filterGroup;\n $filter = $this->filter;\n $filter->setField('entity_id');\n $filter->setValue('10');\n $filter->setConditionType('eq'); \n $filterGroup->setFilters([$filter]);\n $searchCriteria->setFilterGroups([$filterGroup]);\n $orderList = $repository->getList($searchCriteria);\n foreach ($orderList->getItems() as $order) {\n $extensionAttribute = $order->getExtensionAttributes();\n $returnArr = [\n $extensionAttribute->getCustomCol1(),\n $extensionAttribute->getCustomCol2()\n ];\n }\n return $returnArr;\n }\n}<\/pre>\n\n\n\n![\"Join\"](\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/08\/Join.png\")
<\/figure>\n\n\n\n