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

Related Posts	Replies	Views
Filter individuals based on parent company field domain filtering studio	3 अक्तू॰ 18	4762
Filter many2one field domain many2one filtering	3 सित॰ 16	6703
Domain Filtering issue domain one2many filtering	0 मार्च 15	4245
filtering of purchase order products purchase domain filtering	1 मार्च 15	4548
naked domain set up Solved domain	3 जुल॰ 25	6081

This question has been flagged

Enjoying the discussion? Don't just read, join in!