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:

İlgili Gönderiler	Cevaplar	Görünümler
Create schedule action For sending emails odoo10	2 Tem 25	4968
How to send messages that are not shown in chatter? odoo10	2 Ara 24	7986
How to ORDER BY? [Odoo 10] Çözüldü odoo10	2 Kas 24	28789
Dynamic domain functionality - possible to change domain of a field in another model with onchange? (Odoo 10) Çözüldü odoo10	2 May 24	7662
Change state of other module odoo10	3 Mar 24	7114

Bu soru işaretlendi

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