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	4104
Filter many2one field domain many2one filtering	3 9月 16	6196
Domain Filtering issue domain one2many filtering	0 3月 15	3641
filtering of purchase order products purchase domain filtering	1 3月 15	4207
naked domain set up 已解決 domain	3 7月 25	4292

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！