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

Verknüpfte Beiträge	Antworten	Ansichten
Filter individuals based on parent company field domain filtering studio	3 Okt. 18	4099
Filter many2one field domain many2one filtering	3 Sept. 16	6193
Domain Filtering issue domain one2many filtering	0 März 15	3640
filtering of purchase order products purchase domain filtering	1 März 15	4198
naked domain set up Gelöst domain	3 Juli 25	4277

Diese Frage wurde gekennzeichnet

Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!