Questions tagged [join-table]
The join-table tag has no usage guidance.
6
questions
5
votes
4
answers
35k
views
Magento 2: join custom table with product collection while sql query is running fine
I trying to join custom table with product collection but I am not getting result. But printed SQL query is running fine
namespace Vendor\Module\Block\Product;
use Magento\Catalog\Api\...
- 939
8
votes
1
answer
15k
views
How to join product collection of magento 2 to a custom table?
I have a custom table user_product_table with a field sku(this field join to product collection) and user. How can I join this table with product collection, so that I don't have to loop my custom ...
- 601
6
votes
5
answers
4k
views
Magento Admin Order Grid Filter by "Status" giving error while joined with "sales_flat_order" table
I am working on a project where there is custom column already installed on sales_flat_order table.
I know, in order grid magento uses sales_flat_order_grid table to fetch data.
I have used join ...
- 8,330
3
votes
1
answer
2k
views
Get Product name in grid
In custom module i m saving product id in my table using that i want to display product name in admin grid
I m trying this code to join table
$collection->getSelect()
->joinLeft(
...
- 1,604
1
vote
1
answer
1k
views
Magento 1.9.x - I want to join first name and last name in customer grid
I want to get fullname of customers in magento back-end server.
I already brought the first name in index "NAME" and i want to join the lastname after first name.
protected function ...
- 594
0
votes
1
answer
130
views
M2.1.9- I used the method which joining table when adding column to order grid. But it is so slow and filter function disappear
There,
I used the method which joining table when adding new column to order grid. A new column is for company name and its information is from sales_order_address, not sales_order. I succeeded to ...
- 594