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	Odpovědi	Zobrazení
Create schedule action For sending emails odoo10	2 čvc 25	4861
How to send messages that are not shown in chatter? odoo10	2 pro 24	7924
How to ORDER BY? [Odoo 10] Vyřešeno odoo10	2 lis 24	28737
Dynamic domain functionality - possible to change domain of a field in another model with onchange? (Odoo 10) Vyřešeno odoo10	2 kvě 24	7607
Change state of other module odoo10	3 bře 24	7062

This question has been flagged

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