Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
5 Odpovědi
35603 Zobrazení

Using Domain how to filter one2many Fields (job_ids) is equal to [] or job_ids.contact_id is null.

domain="[('job_ids','=',[])]"

domain="[('job_ids.contact_id','=',False)]"

Tried the above 2 code is not working

Thanks

Avatar
Zrušit

What do you exactly want to do?

The second one cannot work, you are demanding the contact_id of a list of job_ids

Nejlepší odpověď

To define a domain in a One2many field you must write it in the python file and the code goes without quotes:

Example: 

'job_ids': fields.One2many(
         ...
         domain=[('contact_id','=',False)]
​)

the quotes were the problem in all previous answers








Avatar
Zrušit
Autor Nejlepší odpověď

Actual requirement contact name shows only not related partner.

The below domain is not working job_ids is one2many field in res.partner.contact

'contact_id' : fields.many2one('res.partner.contact', 'Contact', domain="[('job_ids','=',[])]"),
Avatar
Zrušit
Autor

Solved domain="[('job_ids','=',False)]")

Okay, I misunderstood your question. I have deleted my answer.

Nejlepší odpověď

See example :

display_record is a  boolean field in one2many.

Setting  attrs in all fields.

<tree>
    <field name="field_1" attrs="{'invisible': [('display_record','=',False)]}"/>
    <field name="field_2" attrs="{'invisible': [('display_record','=',False)]}"/>
    <field name="field_3" attrs="{'invisible': [('display_record','=',False)]}"/>
    <field name="field_4" attrs="{'invisible': [('display_record','=',False)]}"/>
    <field name="field_5" attrs="{'invisible': [('display_record','=',False)]}"/>
    <field name="dispaly_record" invisible="1"/>
</tree>

If the value of dispaly_record  is False, the entire row will be invisible. 


Avatar
Zrušit
Nejlepší odpověď

To filter in many2one, one2many and many2many, you have to directly use the fields of the related object.

For exemple:

'job_ids': fields.on2many(
         ...
         domain="[('contact_id','=',False)]")
Avatar
Zrušit
Nejlepší odpověď

Change your second domain as:

domain="[('job_ids.id.contact_id','=',False)]"


Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
1
čvn 24
4208
1
pro 23
19408
1
čvc 15
6147
2
bře 15
6349
1
bře 15
7298