This question has been flagged
1 Reply
3397 Views
res.partnerv14
Avatar
SmithJohn45

please help to solve the problem below, in GUI it is showing field "category_id" in res.partner but when querying through psql it is showing error, check both screenshots below:

connected with same db (odb), here is postgresql session screenshot where it says "category_id" does not exist


Settings -> Technical -> Database Structure -> Models

searched for partner, then selected res.partner, it shows as below


regards

Avatar
Discard
Avatar
Kiran K
Best Answer

Hi ,

The category_id is not stored in the res_partner table.


category_id = fields.Many2many('res.partner.category', column1='partner_id',
 column2='category_id', string='Tags', default=_default_category)

Since it's a many2many field , it is stored in a relational table ,

Odoo will create a new relational table linking the two models res_partner and res_partner_category. The table will have a name like this.


 'res_partner_res_partner_category_rel'


select p.id,p.name,rel.category_id from res_partner p left join res_partner_res_partner_category_rel rel on p.id = rel.partner_id


Hope it Helps ,

Kiran K

Avatar
Discard
SmithJohn45
Author

thanks @Kiran Mohan... so, it is misleading in gui which is showing it under res.partner model or i misunderstood for many2many type fields? how i can reference it in my query above?

SmithJohn45
Author

thanks @Kiran Mohan, when i posted my last comment on your answer, after it i saw your completed post which includes all things i need. thanks again :)