How to join model in xmlrpc using ripcord?

Question

I have 2 model : product.template and product.brand. i want to show detail data from product.template and its brand which the brand i can get from product.brand's model. In model product.brand contain product_id which have relation with id in product.template. Here's my current code. This code only showing data from product.template.

<?php    
$products = $ripcord->execute_kw('myDB', 1, 'myPassword',
                        'product.template', 'search_read',
                        array(
                            array(
                            array('name', 'ilike', 'pixma'),
                            array('type', 'ilike', 'product'),
                        ['fields'=>array('name', 'description'), 'limit'=>5]
                     ))); 
?>

How can i join the product.template model with product.brand so that i can get data's product brand. Thank You.

Answer 1

You need to include the reference to brand in fields.

<?php

$db = 'myDB';
$uid = 1;
$password = 'myPassword';

# You will need to include a reference to the Many2one field
# that exists on your product.template record. I'm assuming it's
# called something like "brand" or "brand_id"
$fields = array('name', 'description', 'brand');


$products = $ripcord->execute_kw($db, $uid, $password,
    'product.template', 'search_read', array(array(
        array('name', 'ilike', 'pixma'),
        array('type', 'ilike', 'product'),
        ['fields'=> $fields, 'limit'=>5])));