Skip to Content
This question has been flagged
filtererrorcontacts
3 Replies
13056 Rodiniai
Portretas
Siobhan

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?

Portretas
Atmesti
Portretas
Siobhan
Autorius Best Answer

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


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

Portretas
Atmesti
Portretas
Zbik
Best Answer

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)]" />
Portretas
Atmesti
Siobhan
Autorius

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

Related Posts Replies Rodiniai Veikla
Contacts as Vendors
filter contacts vendor
Portretas
Portretas
Portretas
Portretas
3
kov. 24
5301
filter all contacts from "active" companies
accounting filter contacts
Portretas
Portretas
1
lapkr. 22
2779
[domain filter] why using "employee_id.user_id = uid" as filter rather than "employee_id = uid" Solved
filter domain contacts
Portretas
Portretas
2
kov. 18
12304
Error while Importing Contacts from a CSV File
error contacts importing cvs
Portretas
Portretas
1
rugp. 24
2402
Module error
error module contacts owl
Portretas
0
vas. 24
2370