Magento 2.2.3 - Full text filter not working for sales order grid

Question

The full-text search filter is not working for sales order grid. Other filters are working correctly for sales order grid.

Answer 1

You need to check sales_order_grid table and make sure that you have full text index for increment_id field. If there is not any index for increment_id you need to add using below script.

if (version_compare($context->getVersion(), '1.0.4', '<')) {

        $table = $setup->getTable('sales_order_grid');

        $setup->getConnection()
            ->addIndex(
                $table,
                $setup->getIdxName(
                    $table,
                    ['increment_id'],
                    \Magento\Framework\DB\Adapter\AdapterInterface::INDEX_TYPE_FULLTEXT
                ),
                ['increment_id'],
                \Magento\Framework\DB\Adapter\AdapterInterface::INDEX_TYPE_FULLTEXT
            )
        ;
    }

You need to do this using UpgradeDta\Schema.