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

Publicações relacionadas	Respostas	Visualizações
Filter individuals based on parent company field domain filtering studio	3 out. 18	4075
Filter many2one field domain many2one filtering	3 set. 16	6178
Domain Filtering issue domain one2many filtering	0 mar. 15	3623
filtering of purchase order products purchase domain filtering	1 mar. 15	4187
naked domain set up Resolvido domain	3 jul. 25	4184

Esta pergunta foi sinalizada

Está gostando da discussão? Não fique apenas lendo, participe!