Skip to Content
This question has been flagged
v6.1
5 Replies
35224 Views
Avatar
Prakash

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
Discard
Andreas Brueckl

What do you exactly want to do?

Yannick Payot

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

Avatar
t.andres0708@gmail.com
Best Answer

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
Discard
Avatar
Prakash
Author Best Answer

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
Discard
Prakash
Author

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

Yannick Payot

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

Avatar
Shameem Babu
Best Answer

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
Discard
Avatar
Yannick Payot
Best Answer

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
Discard
Avatar
SSS
Best Answer

Change your second domain as:

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


Avatar
Discard
Related Posts Replies Views Activity
Manufacturing to delivery, how are scheduled MRP operations?
v6.1
Avatar
1
Jun 24
4208
[Solved] Close window on button press Solved
v6.1
Avatar
1
Dec 23
19134
How open an edit form with a button ?
v6.1
Avatar
1
Jul 15
6147
Please may I have a shortcut example?
v6.1
Avatar
Avatar
Avatar
2
Mar 15
6139
How to save a document to a specified directory?
v6.1
Avatar
Avatar
1
Mar 15
7115