I have save my custom data in quote and sales_order table and show data in Admin grid but filter is not working in this as it is search in sales_order_grid table in Magento 2.

I have found out a solution using virtualType in di.xml but still it doesn't work.

my di.xml file

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd">
<preference for="Reg\Checkout\Api\Data\CustomFieldsInterface" type="Reg\Checkout\Model\Data\CustomFields" />
<preference for="Reg\Checkout\Api\CustomFieldsRepositoryInterface" type="Reg\Checkout\Model\CustomFieldsRepository" />
<preference for="Reg\Checkout\Api\CustomFieldsGuestRepositoryInterface" type="Reg\Checkout\Model\CustomFieldsGuestRepository" />
<virtualType name="Magento\Sales\Model\ResourceModel\Order\Grid" type="Magento\Sales\Model\ResourceModel\Grid">
        <argument name="columns">
            <item name="custom_value" xsi:type="string">sales_order.custom_value</item>

Still it doesn't work can anyone point out what's the issue.

Any help is appreciated.


Column not found: 1054 Unknown column 'custom_value' in 'where clause', query was: SELECT COUNT(*) FROM `sales_order_grid` AS `main_table` WHERE (`custom_value` = 'facebook') AND (`custom_value` LIKE '%facebook%') {"exception":"[object] (Zend_Db_Statement_Exception(code: 42): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'custom_value' in 'where clause', query was: SELECT COUNT(*) FROM `sales_order_grid` AS `main_table` WHERE (`custom_value` = 'facebook') AND (`custom_value` LIKE '%facebook%') at /var/www/html/mag/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:110, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'custom_value' in 'where clause' at /var/www/html/mag/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:91)"} []

2 Answers 2


You can also add column in sales_order_grid.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">
    <listingToolbar name="listing_top">
        <filters name="listing_filters">
                <filterSelect name="custom_value" provider="${ $.parentName }" component="Magento_Ui/js/form/element/ui-select" template="ui/grid/filters/elements/ui-select">
                        <options class="Vender\Module\Model\Config\Source\CustomValueOptions"/>
                        <caption translate="true">...Select...</caption>
                        <label translate="true">Sales Custom Value</label>
                            <link name="visible">componentType = column, index = ${ $.index }:visible</link>
    <columns name="sales_order_columns">
        <column name="custom_value">
            <argument name="data" xsi:type="array">
                <item name="config" xsi:type="array">
                    <item name="filter" xsi:type="string">text</item>
                    <item name="visible" xsi:type="boolean">true</item>
                    <item name="sortOrder" xsi:type="number">25</item>
                    <item name="label" xsi:type="string" translate="true">Custom Value</item>

Afetr this in this file :- Vender\Module\Model\Config\Source\CustomValueOptions


namespace Vendor\Module\Model\Config\Source;

use Magento\Framework\Data\OptionSourceInterface;

class CustomValueOptions implements OptionSourceInterface
    protected $userFactory;
    public $_options;

    public function __construct(\Magento\User\Model\UserFactory $userFactory)
        $this->userFactory = $userFactory;

    public function toOptionArray()
        $this->_options = [];
        $this->_options[] = ['label' => 'label1','value' => 'value1'];
        $this->_options[] = ['label' => 'label2','value' => 'value2'];
        $this->_options[] = ['label' => 'label3','value' => 'value3'];
        return $this->_options;


  • Thanks for the response i have added the column in the same file and it shows the only issue is filters are not working @RkRathod
    – Prits
    Commented Sep 30, 2020 at 9:35
  • check updated answer Commented Sep 30, 2020 at 9:47
  • Thanks for your response but the filter is not working yet i have checked log it shows me Column not found: 1054 Unknown column 'custom_value' in 'where clause', query was: SELECT COUNT(*) FROM sales_order_grid AS main_table WHERE (custom_value = 'facebook') AND (custom_value LIKE '%facebook%')
    – Prits
    Commented Sep 30, 2020 at 10:16
  • which error ??? Commented Sep 30, 2020 at 10:17
  • Added my full error in question please check @RkRathod
    – Prits
    Commented Sep 30, 2020 at 10:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.