Odoo Help


[Solved] Filtering res.partner for contact (child_ids) - Odoo8

on 6/10/15, 3:34 AM 2,129 views

I have a test company created with 2 contacts.

I would like that in my module when I select the Company (marked is company) that in another field it only shows contact for that company

In developer mode, I found contacts to have name "child_ids" and I thought maybe if I added this:

<field name="res_partner_id" domain="[('child_ids', '=', True)]" />

it would work:

However it gives error:

ProgrammingError: operator does not exist: integer = boolean

LINE 1: SELECT "parent_id" FROM "res_partner" WHERE "id" IN (true)


HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

Any ideas on how to fix this?

On 6/11/15, 2:59 AM

Found solution. It needs to be filter on the parent not the child:

<field name="res_partner_id" domain="[('parent_id', '=', res_partner_id)]" />



| 6 5 7
Lodz, Poland

On 6/10/15, 2:09 PM

Try this (False is set when list is empty, if is not empty .... not equals True):

<field name="res_partner_id" domain="[('child_ids', '!=', False)]" /> 

Thanks Zbik but that just gave me the customer names and not the contacts associate with the customer

on 6/11/15, 1:49 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 6/10/15, 3:34 AM
Seen: 2129 times
Last updated: 6/11/15, 2:59 AM