Magento – how to create grid using ui component with multi table(JOIN) in magento2

gridjsonmagento2uicomponent

I have created a grid with UI component with one table now I want to join another table so how can I create??

i try but not working
in
Vendorname\Modulename\Model\ResourceModel\Quote\collection.php

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

        $this->getSelect()->joinLeft(
                ['secondTable' => $this->getTable('quote_customer')],
                'main_table.mcs_quote_id = secondTable.quote_request_id',
                array('*')
            );
    }

Thanks in advance.

Best Answer

You can display values from join two tables by using below model resource collection class function

Add below function to your model resource collection function

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

        $this->getSelect()->joinLeft(
                ['secondTable' => $this->getTable('tablename')],
                'main_table.columnname = secondTable.columnname',
                ['columnname1','columnname2','columnname3']
            );
    }

You can get more information from here magento2: admin grid showing joined table

Related Solutions

Magento – Magento 2 : How to add a product grid (assign product) in custom module using UI Component

Issue is you are calling a wrong method with product object in

Step3: Create Product.php in Namespace\Module\Block\Adminhtml\Products\Edit\Tab\

Just comment following code block in above example,

/*if ($this->getItem()->getProductsReadonly()) {
            $productIds = $this->_getSelectedProducts();
            if (empty($productIds)) {
                $productIds = 0;
            }
            $this->getCollection()->addFieldToFilter('entity_id', ['in' => $productIds]);
        } */

Magento2 – Show Custom Table Data as Options for Select Dropdown in UI Component Grid Form

After trying few methods I managed to get the options as below:

namespace [Vendor]\[Module]\Model\Select\Source;
use Magento\Framework\Option\ArrayInterface;
class Options implements ArrayInterface
{
    protected $options;
    public function __construct(
        [Vendor2]\[Module2]\Model\SellersFactory $sellersFactory
    ) {
        $this->sellersFactory = $sellersFactory;
    }
    public function toOptionArray()
    {
        $sellerModel = $this->sellersFactory->create()->getCollection()
                                           ->addFieldToSelect( array('user_id','storetitle','name') );
        $options = array( 'label' => 'Please select', 'value' => ''  );
        if( $sellerModel->getSize() ){
            foreach ( $sellerModel  as $seller) {
                $options[] = array( 
                'label' => ucfirst( $seller->getData('storetitle') ) ,
                'value' => $seller->getData('user_id')
                );
            }
        }
        return $options;
    }
}

Not sure if this is the best method though. Please share if there is a better way. Thank you

Best Answer

Related Solutions

Magento – Magento 2 : How to add a product grid (assign product) in custom module using UI Component

Magento2 – Show Custom Table Data as Options for Select Dropdown in UI Component Grid Form

Related Topic