example: i have a table "table_1" i want to join product collection to get the product data? but I don't know how to join product collection? so everybody can help me pls?
List item
-
1What join you need and what is relationShip Between Magento product collection & table_1.– Amit Bera ♦May 3, 2019 at 9:04
-
Where you want to join?– Amit Bera ♦May 3, 2019 at 9:04
-
i want get all attribute of product for column controls in my grid– NewBieMay 3, 2019 at 9:20
Add a comment
|
1 Answer
Found this one, you can try it (this is untested):
$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$collection = $objectManager->get('Magento\Catalog\Model\ResourceModel\Product\CollectionFactory')->getCollection();
$collection->getSelect()->join( array('custom_table'=> 'table_1'), 'custom_table.id = main_table.entity_id', array('custom_table.sku'));
-
i want get product collection from custom_table. because i use custom_table and get data product from it– NewBieMay 3, 2019 at 9:49
-