Can I filter value based on another field in form view?

Question

class HelpdeskTeam(models.Model):
....
category_ids= fields.Many2many(comodel_name="helpdesk.ticket.category", string="Category")
....
class HelpdeskTicket(models.Model):
....
team_id= fields.Many2one(comodel_name="helpdesk.ticket.team",string="Area")
category_id= fields.Many2one(comodel_name="helpdesk.ticket.category",string="Category")
....
in the form view:
....
... fieldname="category_id"domain="[(category_id, 'in', 'team_id.category_ids')]" ...
....
Can I add a conditional field to show spe

Cybrosys Techno Solutions Pvt.Ltd · Accepted Answer

Hi,
You can add domain for one field based on another field using onchange.

@api.onchange('team_id')
def get_categories(self):
​if self.team_id:
​ 	 ​domain = [('field_name', '=', value)]
​else:
​ 	 ​domain = []
​return {'domain': {'category_id': domain}}
You can read more about dynamic domain from this blog:
https://www.cybrosys.com/blog/how-to-apply-dynamic-domain-for-relational-fields-in-odoo-16 [1]

Hope it helps!

[1] https://www.cybrosys.com/blog/how-to-apply-dynamic-domain-for-relationa

Niyas Raphy (Walnut Software Solutions) · Answer

Hi,
Using the domain attribute you can filter the value listed in all the fields, the domain expression has to be written in the needed format. Domain can be applied in python level as well as in the view level.

If you look at this video, you will get detailed idea about it and you can map it according to your need:
https://www.youtube.com/watch?v=dq5Vtj_pwuI [1]

Thanks

[1] https://www.youtube.com/watch?v=dq5Vtj_pwuI

相关帖文	回复	查看
Filter individuals based on parent company field domain filtering studio	3 10月 18	3999
Filter many2one field domain many2one filtering	3 9月 16	6116
Domain Filtering issue domain one2many filtering	0 3月 15	3562
filtering of purchase order products purchase domain filtering	1 3月 15	4134
naked domain set up 已解决 domain	3 7月 25	3874

此问题已终结

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