Ttdfjt

i want to add a custom column in customer grid like "is_approved" customer section.
please suggest.

• First you need to create an customer attribute is_approve
  

app/code/Namespace/Modulename/Setup/InstallData.php

Note Make sure you add 'is_used_in_grid' => true, in your attribute options or you may get sql error.

<?php 

namespace NamespaceModulenameSetup; 

use MagentoCustomerSetupCustomerSetupFactory;
use MagentoCustomerModelCustomer;
use MagentoEavModelEntityAttributeSet as AttributeSet;
use MagentoEavModelEntityAttributeSetFactory as AttributeSetFactory;
use MagentoFrameworkSetupInstallDataInterface;
use MagentoFrameworkSetupModuleContextInterface;
use MagentoFrameworkSetupModuleDataSetupInterface;

class InstallData implements InstallDataInterface


 /**
 * @var MagentoCustomerSetupCustomerSetupFactory
 */
 private $customerSetupFactory;

 /**
 * @var MagentoEavModelEntityAttributeSetFactor
 */
 private $attributeSetFactory; 

 /**
 * Init
 *
 * @param MagentoCustomerSetupCustomerSetupFactory $customerSetupFactory
 */
 public function __construct(
 CustomerSetupFactory $customerSetupFactory,
 AttributeSetFactory $attributeSetFactory
 ) 
 $this->customerSetupFactory = $customerSetupFactory;
 $this->attributeSetFactory = $attributeSetFactory;
 

 public function install(ModuleDataSetupInterface $setup, ModuleContextInterface $context) 
 /** @var CustomerSetup $customerSetup */
 $customerSetup = $this->customerSetupFactory->create(['setup' => $setup]);

 $customerEntity = $customerSetup->getEavConfig()->getEntityType('customer');
 $attributeSetId = $customerEntity->getDefaultAttributeSetId();

 /** @var $attributeSet AttributeSet */
 $attributeSet = $this->attributeSetFactory->create();
 $attributeGroupId = $attributeSet->getDefaultGroupId($attributeSetId);

 $customerSetup->addAttribute(Customer::ENTITY, 'is_approve', [
 'type' => 'int',
 'label' => 'Is Approved',
 'input' => 'select',
 'required' => false,
 'visible' => true,
 'user_defined' => true,
 'sort_order' => 1001,
 'position' => 1001,
 'is_used_in_grid' => true,
 'system' => 0,
 'source' => 'MagentoEavModelEntityAttributeSourceBoolean',
 'adminhtml_only'=>1,
 'default'=>0
 ]);

 $attribute = $customerSetup->getEavConfig()->getAttribute(Customer::ENTITY, 'is_approve')
 ->addData([
 'attribute_set_id' => $attributeSetId,
 'attribute_group_id' => $attributeGroupId,
 'used_in_forms' => ['adminhtml_customer'],
 ]);

 $attribute->save();
 

• Display it in the customer listing create ui component

app/code/Namespace/Modulename/view/adminhtml/ui_component/customer_listing.xml

<?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="customer_columns" class="MagentoCustomerUiComponentListingColumns">
 <column name="is_approve">
 <argument name="data" xsi:type="array">
 <item name="config" xsi:type="array">
 <item name="filter" xsi:type="string">select</item>
 <item name="editor" xsi:type="string">select</item>
 <item name="component" xsi:type="string">Magento_Ui/js/grid/columns/select</item>
 <item name="dataType" xsi:type="string">select</item>
 <item name="label" xsi:type="string" translate="true">Is Approved</item>
 <item name="sortOrder" xsi:type="number">51</item>
 </item>
 </argument>
 </column>
 </columns>
</listing>

• Finally add the attribute to the customer grid index
  

app/code/Namespace/Modulename/etc/indexer.xml

<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Indexer/etc/indexer.xsd">
 <indexer id="customer_grid">
 <fieldset name="customer">
 <field name="is_approve" xsi:type="filterable" dataType="int"/>
 </fieldset>
 </indexer>
</config>

• run command php bin/magento indexer:reindex and check.

Here is my solution. I have created my own module. My custom attribute is from another table and another module so ihave created this module.

https://magento.stackexchange.com/a/237030/63460