Menu Close
    Start a Project Request quote Reading list Switch to dark mode
    magento-marketplace-mod

    How to apply join in collection in UIComponent Grid in magento2

    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:

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


    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’)

    . . .

    Comment

    Add Your Comment

    Be the first to comment.

    Back to Top
    css.php
    Hire Us!
    Brief us about your requirements and we'll get back to you.
    Woo! Hooy!
    We have just recieved your project brief and our expert will contact you shortly.
    Send Again
    Close