Magento 2 – How to Add New Column to Table customer_grid_flat

customermagento2

I want to add new column for table customer_entity and customer_grid_flat. please help me , how way to do it. thanks
my code :

    ...
    InstallSchema:
        $eavTable = $installer->getTable('customer_entity');
        $columns = [
            'custom_field' => [
                'type' => \Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
                'length' => '6',
                'nullable' => false,
                'default' => 0,
                'comment' => 'del flg',
                'after' => 'gender'
            ]
        ];
        foreach ($columns as $name => $definition) {
            $connection->addColumn($eavTable, $name, $definition);
        }
...
    InstallData:
...
            $customerSetup->addAttribute('customer', 'custom_field', [
                'type' => 'static',/* Data type in which formate your value save in database*/
                'label' => __('custom_field'),
                'input' => 'text',
                'visible' => false,
                'required' => false,
                'is_used_in_grid' => true,
                'is_visible_in_grid' => false,
                'is_filterable_in_grid' => false,
                'is_searchable_in_grid' => false
            ]);

            /**
             * @var EavSetupFactory $eavSetup
             */
            $attribute = $customerSetup->getEavConfig()->getAttribute('customer', 'custom_field');
            $attribute->setData('used_in_forms', [
                'adminhtml_customer'
            ]);
            $attribute->save();
    ...

I want to create the column customer_grid_flat.custom_field that get value from customer_entity.custom_field.

Best Answer

I find my solution here:
Step1:Create file your_module/etc/indexer.xml with content

<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:noNamespaceSchemaLocation="urn:magento:framework:Indexer/etc/indexer.xsd">
    <indexer id="customer_grid" view_id="dummy" class="Magento\Framework\Indexer\Action\Entity" primary="customer">
        <fieldset name="customer" source="Magento\Customer\Model\ResourceModel\Customer\Collection"
                  provider="Magento\Customer\Model\Indexer\AttributeProvider">
            <field name="custom_field" xsi:type="filterable" dataType="int"/>
        </fieldset>
    </indexer>
</config>

Step2: run command : php bin/magento indexer:reindex

Related Solutions

Add New Column to Existing Table with InstallSchema in Magento 2

First, I'm assuming when you say that nothing happens, you mean that the setup script runs as usual, but no errors are output and no changes were made to your database. If this isn't a correct assumption, please let me know!

When I do an upgrade to the schema, I don't do a getTable(), I think that that is superfluous.

I tested the above script with that change, and it worked, so the two troubleshooting steps I would take are to:

Ensure that you have incremented the setup_version in your module.xml (or your script won't run at all)
Add some obvious error in your upgrade script to see if it is running at all...if there is an error and the script is running, you will get error messages when running setup:upgrade

I hope that helps!

Magento 2 – How to Add New Column in quote_item Table

You can add column like this

namespace [Name]\[Modulename]\Setup;

use Magento\Framework\Setup\InstallSchemaInterface;
use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\Setup\SchemaSetupInterface;
class InstallSchema implements InstallSchemaInterface
{

/**
 * {@inheritdoc}
 * @SuppressWarnings(PHPMD.ExcessiveMethodLength)
 */
public function install(SchemaSetupInterface $setup, ModuleContextInterface    $context)
  {
    $installer = $setup;

    $installer->startSetup();

    $eavTable = $installer->getTable('quote_item');

    $columns = [
        'customname' => [
            'type' => \Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
            'nullable' => false,
            'comment' => 'customname',
        ],

    ];

    $connection = $installer->getConnection();
    foreach ($columns as $name => $definition) {
        $connection->addColumn($eavTable, $name, $definition);
    }

    $installer->endSetup();
}
}

Using this code you can add column in quote_item table

Related Topic

Magento2 Database – Purpose of Customer_grid_flat Table