This question has been flagged
2 Replies
1367 Views

i have 2 fields in my model source_location and destination_location

if i choose a country in source_location and i want to set  that country not visible in destination_location 

these 2 are many2one fields

Avatar
Discard
Best Answer

Hi ,
Try to add the domain in the destination location like:

 < field name="source_location"/ >
< field name="destination_location" domain="[('id', '!=', source_location)]"/ >


Please vote the answer if it work.

Avatar
Discard
Best Answer
** Assuming this two fields have Many2one connection with res.country **
from odoo import models, api


class YourClass(models.Model):
_inherit = 'module.model'

@api.onchange('source_location')
def set_domain_destination_location(self):
for rec in self:
domain = {'destination_location': [('id', '!=', rec.source_location.id)]}
return {'domain': domain}


Avatar
Discard

Hi Arian Shariat,
The domain will only active if you change or select the source location. Otherwise the domain will inactive and you can select any value in the destination location. So the best way is the domain on a field instead of onchange.

@Malay Hi Malay
You are right. In my approach, the source_location value should be chosen first and then the domain for destination_location domain will be applied. But I can't find any contradiction between this approach and what the question is.

Hi Arian Shariat,
He can able to select same country value if he select the same destination country first.

Yes he can use on change if he wants to omit this scenario. But the best way is still the domain on a field.

You are right about that Malay. I'll change my answer based on it. Thanks