Questions tagged [join]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
2answers
1k views

Item (Mage_Core_Model_Store_Group) with the same id “2” already exist

I am joining core_store_group with my custom table called foundation and I am Getting values also. My custom table contain 3 fields ID, STORE_ID, EMAIL Where ID is primary key and store_id is ...
0
votes
1answer
2k views

How to join Sales order collection and order item collection

I want to join the sales order collection and sales order item collection How to join the two collection I have collections like order collection > $ordercollection=$this->orderCollection-...
0
votes
1answer
2k views

Magento 2 Join table customer entity and customer address entity

I am trying to join customer entity table and customer address entity table. I am getting error in below code. What could be the issue $agency_name=$customerData->getDefaultShippingAddress(...
0
votes
1answer
696 views

Left join order grid collection using observer method. Magento 1.9

I'm trying to add a grid to order listing table following this awesome blog which works if all code copied but I'm unable to customize it. And I want to show the data from my custom table. I've ...
0
votes
1answer
812 views

Left join on custom collection, to get product name by product ID

There's a collection which contains product ids. I'd like to join it with the magento table that stores paroduct names, in order to add product name to collection. $collection = Mage::getModel("...
0
votes
1answer
427 views

After join, use the result join again in Magento2

For example, I create a table which has product sku, I use the table LEFT JOIN `catalog_product_entity` table to get the entity_id, then want to use the entity_id result to LEFT JOIN `...
0
votes
2answers
578 views

JoinField Show error same id is already exists

We want to change below line: ->joinField('store_credit','kartparadigm_storecredit_creditinfo','total_credits', 'c_id=entity_id', null, 'left'); with this one: ->joinField('store_credit','...
0
votes
2answers
5k views

I am getting an error General error: 1111 Invalid use of group function. What am I doing wrong?

I have this code $orderModel = Mage::getModel('sales/order'); $ordercollection = $orderModel->getCollection() ->setPageSize(20) ->setCurPage(1) ->join(array('...
0
votes
1answer
462 views

How to LEFT-JOIN 'catalog/category' fields to 'sales/order_item' collection?

I'm trying to left-join some of the 'catalog/category' attributes to a 'sales/order_item' collection. For example: a satisfying result will let me add the category-name to the order-item data. *I ...
0
votes
1answer
789 views

Unrecognized method 'isLoaded()' in Magento 2

I'm trying to join product and my custom table but it's returning error Unrecognized method 'isLoaded()' my code is: /** * @param \Magento\Backend\Block\Template\Context $context * @param \...
0
votes
2answers
123 views

Complex custom collection join problem

I have created tables, models etc for an extention and can get collections from each model individually fine. Here are the tables in question: orders_table entity_id | magento_order_id | ...
0
votes
1answer
289 views

Magento join query results

I am running a join query on two tables in Magento, this is the query : $collection = Mage::getModel('sales/flat_shipment_track')->getCollection(); $collection->getSelect()->join( ...
0
votes
0answers
8 views

Magento 2 | Join a table to getLoadedProductCollection()

I'm trying to join the tier price table to the getLoadedProductCollection () collection located in the list.phtml file. What I would like to do is filter the products in the current category by tier ...
0
votes
0answers
23 views

(Magento 2) Backend Grid with Joined Tables : UI Component - “Something went wrong” error

Introduction I have created a new module with CRUD functionality. This is on Magento 2.3.5 Issue I have a grid with joined tables as a resultset that I can't get to work. Relevant information The ...
0
votes
0answers
10 views

Why does filtering on a grid based on a joined collections lead to integrity constraint violation due to ambiguous column even after aliasing?

I am trying to render an additional 'Role' column on an existing grid based on the admin/user table. I need to join with with admin/role table twice to get the role owing to the hierarchical design w....
0
votes
0answers
11 views

Collection join to diffrent databases table

My Magento project has 2 connetions: default,whmanager. $joinConditions = 'main_table.product_id = catalog_product_entity.entity_id'; $collection->getSelect()->join( ['...
0
votes
0answers
21 views

Filter and sorting not working in custom culumn in upsell_product_listing.xml

I have joined column qty to Magento\Catalog\Model\ResourceModel\Product\Collection But Sorting filter by qty not working and sorting too in upsell_product_listing /app/code/Vendor/UpsellProducts/etc/...
0
votes
1answer
71 views

How to compare value inside array in magento 2 join query?

$this->getSelect()->join( ["address" => "sales_order_address"], 'main_table.entity_id = address.parent_id AND address.address_type = "shipping"', array('region') )->joinLeft( ["so" => "...
0
votes
2answers
647 views

Magento 1.9 : How to combine two collection data?

I have two different collection one is of order payment transaction and other one is of sales order as show below: $transactionData=Mage::getModel('sales/order_payment_transaction')->getCollection(...
0
votes
0answers
437 views

Magento 2; joinLeft() not working

I have this code to join status to the order item collection: $orderItems = $this->orderItemCollection->addFieldToSelect( array('item_id','order_id', 'created_at', 'updated_at','...
0
votes
1answer
960 views

How i can join eav_attribute_option_value table into my collection and get from him “frontend_label” of colors?

I have a products collections. But in "color" i see option_id number. Mage::getModel('catalog/product') ->getCollection() ->addStoreFilter(Mage::app()->...
0
votes
1answer
415 views

Sorting Collection after joinField not working

I have a collection of products which I filter and show out of stock items only and it works fine. This is what I have: $collection = Mage::getResourceModel('reports/product_collection') ->...
0
votes
1answer
474 views

How to convert mysql query in magento collection

this is my mysql query . I want to convert in magento collection. reference link https://stackoverflow.com/questions/34253461/repeat-a-result-row-multiple-times-by-value-in-row select Item , ...
0
votes
1answer
581 views

Joining Custom flat table with EAV table not Working [duplicate]

I am Joining two tables by following code $collection = Mage::getModel('commission/commission')->getCollection(); $collection->getSelect()->join( array('customer' => $...

1
2