Sale order field tax many2many relation name

Question

Hi,
Sale order line field, How can i  find it's relation name.
tax_id = fields.Many2many('account.tax', string='Taxes', domain=['|', ('active', '=', False), ('active', '=', True)])

Thanks

Sudhir Arya (ERP Harbor Consulting Services) · Accepted Answer

As relational name is not given in the field definition, system generates the relational table's name automatically. In this case the table name is "*account_tax_sale_order_line_rel*".
There is a following rule for that:
If name is not given, it is automatically generated from provided "*model_name"* and "*comodel_name"* after sorted by alphabetical order (account_tax, sale_order_line = account_tax_sale_order_line_rel)
Original Code in framework:
tables = sorted([model._table, comodel._table])
r

Hilar Andikkadavath · Answer

you can find the related tables from db ending with _rel. for eg:

Related Posts	Replies	Views
Create schedule action For sending emails odoo10	2 Jul 25	4656
How to send messages that are not shown in chatter? odoo10	2 Dec 24	7787
How to ORDER BY? [Odoo 10] Solved odoo10	2 Nov 24	28563
Dynamic domain functionality - possible to change domain of a field in another model with onchange? (Odoo 10) Solved odoo10	2 May 24	7502
Change state of other module odoo10	3 Mar 24	6924

This question has been flagged

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