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
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Bogføring
- Lager
- PoS
- Project
- MRP
Dette spørgsmål er blevet anmeldt
5
Besvarelser
35799
Visninger
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
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','=',[])]"),
Solved domain="[('job_ids','=',False)]")
Okay, I misunderstood your question. I have deleted my 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.
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)]")
Change your second domain as:
domain="[('job_ids.id.contact_id','=',False)]"Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Tilmeld dig| Related Posts | Besvarelser | Visninger | Aktivitet | |
|---|---|---|---|---|
|
1
jun. 24
|
4208 | ||
|
1
dec. 23
|
19522 | ||
|
1
jul. 15
|
6147 | ||
|
2
mar. 15
|
6454 | ||
|
1
mar. 15
|
7427 |
What do you exactly want to do?
The second one cannot work, you are demanding the
contact_idof a list ofjob_ids