Read More
Read More
Menu Close

    How to apply join in collection in UIComponent Grid in magento2

    Magento-Code-Snippet-5

    To create a grid using UI-component in magento 2, please refer following link:

    http://webkul.com/blog/how-to-create-a-grid-using-ui-component/

    To apply join in grid collection you need to add following code in your grid collection file, which is defined in :Webkul\Hello\etc\di.xml

    Add Your code in file:

    Searching for an experienced
    Magento 2 Company ?
    Read More

    Webkul\Hello\Model\ResourceModel\Employee\Grid\Collection

        protected function _renderFiltersBefore() {
           	$joinTable = $this->getTable('customer_grid_flat');
            $this->getSelect()->join($joinTable.' as customer','main_table.entity_id = customer.entity_id', array('*'));
            parent::_renderFiltersBefore();
        }

    Here, $JoinTable: is table with which you want to apply join.
    main_table:  is your grid collection table.
    array(‘*’):  use for accessing all the fields of the table.

    If you want to select specific columns then add those column names in place of ‘*’ under array().

    like: array(‘firstname’=>’firstname’)

    . . .
    Discuss on Helpdesk

    Leave a Comment

    Your email address will not be published. Required fields are marked*


    Be the first to comment.

    Back to Top