I am trying to add a new column to order grid in Magento 2.0. So, i need to do joining to order grid collection. How can I achieve this ? Because, in magento2, the grid uses UI component.
Magento – How to join order grid collection to custom table in Magento2
magento2uicomponent
Related Topic
- Magento 2.1 – Build Grid with Multiple Table Collection Using UI Components
- Magento – How to Join custom table to customer grid collection and show new column in Grid in Magento2
- Magento – Magento 2 – Join product collection to custom table
- Magento – Magento2: How to use Custom Collection Data in UI Component Grid
Best Answer
Magento 2 add custom columns to sales order grid,
To join
to any table(s), using plugin would be the best option as this does not rely on rewrites and makes code lean.
Create the plugin in your module's etc/di.xml
So, we are intercepting
because if you take a look at the
you would see
was injected into
Create a Plugin folder and a plugin class in your module
Here we are observing around event of getReport() method.
Copy
to your module's scope
Delete all contents of your copied sales_order_grid.xml as we don't want to override all the contents.
Enter the following code in your module's sales_order_grid.xml
Now, delete cache from var/cache folder or refresh your cache. You would be able to see your added columns in is sales order grid.