Odoo 14: How i can set Domain filter on Many2one type field

Question

hi all,
I want to add domain filter on field ( field2, field3 ), the filter is based on another Many2one field ( field3 is based on -> field2 is based on -> field1 )
for example:
1) user select a value in field1 (will show all countries to select one)
2) field2 should be filtered as per field1 selected value  (filter to select states in selected country )
3) field3 should be filtered as per field2 selected value (filter to select cities in selected state )
please help.
regards

Cybrosys Techno Solutions Pvt.Ltd · Accepted Answer

Hi
You can add a field as given below in the model for state (eg, res.country.state)
country_id = fields.Many2one( 'res.country' ,  string = 'Country' ,  required = True )  So that you can set the domain in for the field state_id as
state_id = fields.Many2one( 'res.country.state' ,  string = "State" ,  domain = "[('country_id', '=', country_id)]" )  Similarly, you can add a field state_id in the model for city(eg: res.city) as,
state_id = fields.Many2one( 'res.country.state' ,  'State' ,  domain

owais khan · Answer

my other fields trying add domain but not working

相关帖文	回复	查看
Hide some possible choices in a Many2one field many2one v14	2 4月 23	2772
hide many2one record when changing condition many2one v14	2 11月 22	2850
Odoo 14: set filter of Many2one field onchange of another Many2one field many2one v14	1 2月 22	7866
Many2one field is not showing record name on Saving form 已解决 many2one v14	2 12月 21	4132
How to set a kanban view to many2one field in Odoo 14 ? many2one v14	0 10月 21	2266

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！