Magento 2: Grid UI Component Filter issue while collection which is using JOINs with some additional tables

– The Filter issues persist when your collections come up with multiple tables by join queries.

Please check the following changes in the collections file as below:
– You can force the table alias using this addFilterToMap() Method.
– Apply this addFilterToMap() method in your _initSelect() Method of your main collection class.

Add the following code to Your collection class :

protected function _initSelect()
{
    $this->addFilterToMap('xyz', 'main_table.xyz');

    parent::_initSelect();
}

protected function _initSelect()

{

$this->addFilterToMap('xyz', 'main_table.xyz');

parent::_initSelect();

}

Please let us know if this article is helpful to you.

Thanks!

Fill the below form if you have any Magento programming need.

Add an image programmatically from any url in Magento 2
[crayon-6421730041ef3694610671/] Using above fucntion Images can be imported directly from...
Magento 2 : Override the Category view block file
Override view block using di.xml and add the below code...
How to check list of Layout XML called for a specific page in Magento 2?
You can check a list of called layout XML for...
Magento 2 : Setup PWA from Scratch
Follow the below steps to install and set up PWA...
How to remove leading zero’s from the order, invoice and shipment number in Magento 2?
If you want to remove all leading zero's from order,...

Author Info

Hire n. jethva

Let’s have a call

Fill the form & Get Installation Support