İçereği Atla
Bu soru işaretlendi
filtererrorcontacts
3 Cevaplar
12280 Görünümler
Avatar
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?

Avatar
Vazgeç
Avatar
Siobhan
Üretici En İyi Yanıt

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


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

Avatar
Vazgeç
Avatar
Zbik
En İyi Yanıt

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)]" />
Avatar
Vazgeç
Siobhan
Üretici

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

İlgili Gönderiler Cevaplar Görünümler Aktivite
Contacts as Vendors
filter contacts vendor
Avatar
Avatar
Avatar
Avatar
3
Mar 24
4421
filter all contacts from "active" companies
accounting filter contacts
Avatar
Avatar
1
Kas 22
2370
[domain filter] why using "employee_id.user_id = uid" as filter rather than "employee_id = uid" Çözüldü
filter domain contacts
Avatar
Avatar
2
Mar 18
11662
Error while Importing Contacts from a CSV File
error contacts importing cvs
Avatar
Avatar
1
Ağu 24
1665
Module error
error module contacts owl
Avatar
0
Şub 24
1766