Hjdcti

I am trying to add phone number column in my order grid.

I have added new column through sales_order_grid.xml in my ui_component directory. Code is below:

<?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">
 <columns name="sales_order_columns">
 <column name="telephone">
 <argument name="data" xsi:type="array">
 <item name="config" xsi:type="array">
 <item name="filter" xsi:type="string">text</item>
 <item name="label" xsi:type="string" translate="true">Phone Number</item>
 <item name="sortOrder" xsi:type="number">6</item>
 </item>
 </argument>
 </column>
 </columns>
</listing>

What should I do in collection to get phone number?

You added the column in ui_component correctly

Just replace the _renderFiltersBefore function with my function in your module collection class

Path should be Vendor/Yourmodule/Model/ResourceModel/Order/Grid/Collection.php

protected function _renderFiltersBefore()

 $joinTable = $this->getTable('sales_order_address');
 $this->getSelect()->joinLeft($joinTable, 'main_table.entity_id = 
 sales_order_address.parent_id AND sales_order_address.address_type = "shipping"', 
 ['telephone']);
 parent::_renderFiltersBefore();

In Case if you miss it don't forgot to add this argument in your dependency injection di.xml

<argument name="collections" xsi:type="array">
<item name="sales_order_grid_data_source" xsi:type="string">VendorYourmoduleModelResourceModelOrderGridCollection</item>
</argument>

I hope this will help

Please add ui component class for your column as per below.

<?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">
 <columns name="sales_order_columns">
 <column name="telephone" class="VendorModuleUiComponentListingColumnTelephone">
 <argument name="data" xsi:type="array">
 <item name="config" xsi:type="array">
 <item name="filter" xsi:type="string">text</item>
 <item name="label" xsi:type="string" translate="true">Phone Number</item>
 <item name="sortOrder" xsi:type="number">6</item>
 </item>
 </argument>
 </column>
 </columns>
</listing>

Now please add Telephone.php as below

namespace VendorModuleUiComponentListingColumn;

use MagentoSalesApiOrderRepositoryInterface;
use MagentoFrameworkViewElementUiComponentContextInterface;
use MagentoFrameworkViewElementUiComponentFactory;
use MagentoUiComponentListingColumnsColumn;
use MagentoFrameworkApiSearchCriteriaBuilder;

class Telephone extends Column

 protected $_orderRepository;
 protected $_searchCriteria;

 public function __construct(ContextInterface $context, UiComponentFactory $uiComponentFactory, OrderRepositoryInterface $orderRepository, SearchCriteriaBuilder $criteria, array $components = [], array $data = [])
 
 $this->_orderRepository = $orderRepository;
 $this->_searchCriteria = $criteria;
 parent::__construct($context, $uiComponentFactory, $components, $data);
 

 public function prepareDataSource(array $dataSource)
 
 if (isset($dataSource['data']['items'])) 
 foreach ($dataSource['data']['items'] as & $item) 

 $order = $this->_orderRepository->get($item["entity_id"]);
 $telephone = $order->getBillingAddress()->getTelephone();

 // $this->getData('name') returns the name of the column so in this case it would return export_status
 $item[$this->getData('name')] = $telephone;
 
 

 return $dataSource;
 

Please check and let me know if any issue.