CODEWITHSUNDEEP
cakephpjoinmodel
stephen mc
stephen mc

Reputation: 791

Problem with CakePHP model joins, missing fields from joined table.

Im probably missing something painfully obvious here. Im trying to join multiple tables together in Cake, but Im only getting the fields from the first table. Consider the following code..

$joins = array();
$joins[] =  array(
            'table' => 'products', 
            'alias' => 'Product', 
            'type' => 'LEFT',
            'conditions' => array(
                'Device.id = Product.device_id'
            )
    );

$joins[] =  array(
            'table' => 'pricepoints', 
            'alias' => 'Pricepoints', 
            'type' => 'LEFT',
            'conditions' => array(
                'Pricepoints.product_id = Product.id'
            )
    ); 
$all_products = $this->Device->find('all', array("joins" => $joins);

And this returns the following SQL 

SELECT `Device`.`id`, `Device`.`manufacturer_id`, `Device`.`name`, `Device`.`type_id`, `Manufacturer`.`id`, `Manufacturer`.`name` FROM `devices` AS `Device` LEFT JOIN products AS `Product` ON (`Device`.`id` = `Product`.`device_id`) LEFT JOIN pricepoints AS `Pricepoints` ON (`Pricepoints`.`product_id` = `Product`.`id`) LEFT JOIN `manufacturers` AS `Manufacturer` ON (`Device`.`manufacturer_id` = `Manufacturer`.`id`)

ie. it only returns the fields from the parent Model ie. Device. How do I get it to select ALL fields from the join? Im presuming its to do with the way I have my Model relationships set up, but I think I have these set up correctly.

Anyone any advice?

Upvotes: 0

Views: 4523

Answers (2)

Ronny Vindenes
Ronny Vindenes

Reputation: 2361

Do your join by calling bindModel() instead of manually specifying the join. See the cookbook for the details on creating and destroying associations on the fly

Upvotes: 1

pleasedontbelong
pleasedontbelong

Reputation: 20102

you can specify the fields in the find query:

$all_products = $this->Device->find('all', array("fields" => array('Device.*','Product.*','Pricepoints.*')
                                                 "joins" => $joins
);

Hope this helps

Upvotes: 7

Related Questions