Started on building custom module, it has feature to display the GRID view for which need to join multiple tables in collection and render them on GRID and filters.
I have used UI Component from magento2 but I m not able to complete the tasks of joining the multiple tables in collection and prepare the grid view.
Anyone can help me on this.
Best Answer
I created admin grid which has join of two custom tables. you cannot do this by using virtual type in di.xml, so you need to follow these steps and update your
etc/di.xml,
Model/Resource/Modulename/Collection.php add join in this file,
Model/Resource/Modulename/Grid/Collection.php,
IN your etc/di.xml
IN your Model/Resource/Modulename/Collection.php
IN your Model/Resource/Modulename/Grid/Collection.php
Hope that helps.