All Questions

Tagged with
Filter by
Sorted by
Tagged with
0
votes
1answer
30 views

How can get custom table columns on product listing page using product_id of the custom table

On product listing page, I need to show visitor nearest product first. I've a marketplace site and each product have different seller and there is a custom table having seller_id and product_id ...
1
vote
3answers
947 views

How to JOIN TABLES with WHERE clause in Magento 1.9?

I want to join two tables, the customer_entity, and customer_entity_varchar. but I have no idea how to do it. This is my current query: Let's assume I the entity_id is 5 and attribute_id is 139. $...
0
votes
1answer
504 views

Magento 2 : Join 2 tables in Existing collection

I've been trying to join 2 tables with the existing collection of Customers (customer_entity). I've added like below. $items->getSelect()->join('customer_entity_text as second', 'main_table....
0
votes
1answer
229 views

Magento 1.9 join table issue

I'm having an issue with Magento 1.9.2.4 trying to make a join on my collection, here's the problem: Actually I've got a custom table named product_banner which I'm getting by: $collection = Mage::...
1
vote
0answers
239 views

how to join Query for particular customer group and custom customer_entity_varchar attribute?

Here in my collection -> Table structure is : 1,id, mydb,table_name,INT UNSIGNED,,10,3,0 2,userid, mydb,table_name,INT UNSIGNED,,10,5,0 3,transctionid, mydb,table_name,...
1
vote
1answer
897 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 ...
6
votes
1answer
8k 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 ...
0
votes
1answer
368 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 ...
2
votes
2answers
654 views

joinLeft escape string from ON condition

I am wondering if it is possible to escape string inside ON condition, something like binding params inside where condition. This is my code $this->getSelect()->joinLeft( array('...
1
vote
1answer
972 views

Joining two collection / tables

I have situation I want to join two tables having some data related to orders.One table contain order id as increment_id and other table contain order id as order_id.I am joining the tables through ...
2
votes
1answer
2k views

Add attribute filter 'manufacturer' to 'reports/product_collection'

I want to filter reports/product_collection by attribute manufacturer. I try with this: $_productCollection = Mage::getResourceModel('reports/product_collection') ->addAttributeToSelect('...
1
vote
0answers
327 views

Magento customer left join not returning all column from customer table [closed]

I wrote the join query with customer table, its only returning both table matched values only,instead of returning all the left table rows. The Query: $collection = Mage::getModel('customer/customer'...
0
votes
2answers
100 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
485 views

join table product and product option in external script

i'm trying to join the products and product_option table by using this script <?php ini_set('memory_limit',"1000M"); ini_set('display_errors', '1'); set_time_limit(0); define('MAGENTO', realpath(...
2
votes
1answer
7k views

how to join three tables on every time when model load

I want to join three tables on every time when model load (for example on edit from page, on grid page in admin and detail page in front-end etc... ) in my custom module. can you please let me know ...
4
votes
3answers
7k views

How to Get Distinct Entries from Joined Tables Through Join()

This doubt aroused when I am answering one of the question that posted here. But this question is not a continuation of that question, rather a general doubt. Basically I need to get log-customer ...