Magento – Filter search not working for custom admin grid

gridmagento2.2PHPsearch

I have created a custom admin grid. In that search is not working properly. Anyone knows please provide me a solution

ox_homeslider_post_listiong.xml

<filterSearch name="fulltext">
            <argument name="data" xsi:type="array">
                <item name="config" xsi:type="array">
                    <item name="provider" xsi:type="string">ox_homeslider_post_listing.ox_homeslider_post_listing_data_source</item>
                    <item name="chipsProvider" xsi:type="string">ox_homeslider_post_listing.ox_homeslider_post_listing.listing_top.listing_filters_chips</item>
                    <item name="storageConfig" xsi:type="array">
                        <item name="provider" xsi:type="string">ox_homeslider_post_listing.ox_homeslider_post_listing.listing_top.bookmarks</item>
                        <item name="namespace" xsi:type="string">current.search</item>
                    </item>
                </item>
            </argument>
        </filterSearch>

Best Answer

Missing index in your table can cause this effect. Try adding index to your table ie in upgrade script like:

public function upgrade(SchemaSetupInterface $setup, ModuleContextInterface $context)
{
    $setup->startSetup();

    if (version_compare($context->getVersion(), '1.0.1') == -1) {

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

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

    $setup->endSetup();
}

then bin/magento setup:upgrade bin/magento c:c

Related Solutions

Magento – Search in custom admin grid redirects to dashboard

When using ajax for grid refresh ($grid->setUseAjax(true)), it's necessary to define (override) Mage_Adminhtml_Block_Widget_Grid::getGridUrl() to return the proper AJAX content endpoint; this URL will be inserted into the JS. You have done this and have indicated "current module, current controller, grid action" as the arguments.

The next step is to define the indicated controller action to return just the grid content. You can do this a couple of ways: with layout and without. It's more conventional to use layout as it provides flexibility and ensures certain layout-based events are dispatched. Typically you can define a layout update handle with just the grid block declared as an output block. You have done this as well.

However, the controller action which handles the AJAX request needs to not invoke the typical full adminhtml layout, namely the <default> handle. By calling loadLayout(false), the default handle is omitted. For more information, see Mage_Core_Controller_Action::loadLayout():

public function loadLayout($handles = null, $generateBlocks = true, $generateXml = true)
{
    // if handles were specified in arguments load them first
    if (false!==$handles && ''!==$handles) {
        $this->getLayout()->getUpdate()->addHandle($handles ? $handles : 'default');
    }
    // ... etc. ...
}

Magento 2 – Create Admin Grid with Two Tables Using UI Component

Follow the instructions mentioned in this article to create the grid.

Now, follow these steps:

To join, you have to add the following codes in di.xml file:

<?xml version="1.0"?>
<!--
    /**
     * Webkul Grid DI
     *
     * @category    Webkul
     * @package     Webkul_Grid
     * @author      Webkul Software Private Limited
     *
     */
 -->
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd">
    <!-- here we remove virtualType and defile collection as follow-->
    <type name="Webkul\Grid\Model\ResourceModel\Grid\Grid\Collection">
        <arguments>
            <argument name="mainTable" xsi:type="string">wk_grid_records</argument>
            <argument name="eventPrefix" xsi:type="string">wk_records_grid_collection</argument>
            <argument name="eventObject" xsi:type="string">wk_grid_records_collection</argument>
            <argument name="resourceModel" xsi:type="string">Webkul\Grid\Model\ResourceModel\Grid</argument>
        </arguments>
    </type>
    <type name="Magento\Framework\View\Element\UiComponent\DataProvider\CollectionFactory">
        <arguments>
            <argument name="collections" xsi:type="array">
                <!--data provider name which used in grid ui component file -->
                <item name="grid_record_grid_list_data_source" xsi:type="string">Webkul\Grid\Model\ResourceModel\Grid\Grid\Collection</item>
            </argument>
        </arguments>
    </type>
</config>

Then you have to update Collection.php file in app/code/Webkul/Grid/Model/ResourceModel/Grid/Collection.php with the following codes:

/**
 * Webkul Grid collection
 *
 * @category    Webkul
 * @package     Webkul_Grid
 * @author      Webkul Software Private Limited
 *
 */

 namespace Webkul\Grid\Model\ResourceModel\Grid;

 /* use required classes */
 use Magento\Framework\Data\Collection\EntityFactoryInterface;
 use Psr\Log\LoggerInterface;
 use Magento\Framework\Data\Collection\Db\FetchStrategyInterface;
 use Magento\Framework\Event\ManagerInterface;
 use Magento\Store\Model\StoreManagerInterface;
 use Magento\Framework\DB\Adapter\AdapterInterface;
 use Magento\Framework\Model\ResourceModel\Db\AbstractDb;

 class Collection extends 
 \Magento\Framework\Model\ResourceModel\Db\Collection\AbstractCollection
 {
 /**
 * @var string
 */
 protected $_idFieldName = 'entity_id';

/**
 * @param EntityFactoryInterface $entityFactory,
 * @param LoggerInterface        $logger,
 * @param FetchStrategyInterface $fetchStrategy,
 * @param ManagerInterface       $eventManager,
 * @param StoreManagerInterface  $storeManager,
 * @param AdapterInterface       $connection,
 * @param AbstractDb             $resource
 */
public function __construct(
    EntityFactoryInterface $entityFactory,
    LoggerInterface $logger,
    FetchStrategyInterface $fetchStrategy,
    ManagerInterface $eventManager,
    StoreManagerInterface $storeManager,
    AdapterInterface $connection = null,
    AbstractDb $resource = null
) {
    $this->_init('Webkul\Grid\Model\Grid', 'Webkul\Grid\Model\ResourceModel\Grid');
    //Class naming structure 
    // 'NameSpace\ModuleName\Model\ModelName', 'NameSpace\ModuleName\Model\ResourceModel\ModelName'
    parent::__construct($entityFactory, $logger, $fetchStrategy, $eventManager, $connection, $resource);
    $this->storeManager = $storeManager;
}

protected function _initSelect()
{
    parent::_initSelect();

    $this->getSelect()->joinLeft(
        ['secondTable' => $this->getTable('wk_record_temp')], //2nd table name by which you want to join mail table
        'main_table.record_id = secondTable.record_id', // common column which available in both table 
        '*' // '*' define that you want all column of 2nd table. if you want some particular column then you can define as ['column1','column2']
    );
    }

    }

Create Collection.php file in app/code/Webkul/Grid/Model/ResourceModel/Grid/Grid.
Now, you can add 2nd table columns in grid_record_grid_list.xml in app/code/Webkul/Grid/view/adminhtml/ui_component folder.

You can find more information about these steps right here.

Best Answer

Related Solutions

Magento – Search in custom admin grid redirects to dashboard

Magento 2 – Create Admin Grid with Two Tables Using UI Component

Related Topic