Skip to Content
This question has been flagged
modelsopenerp
2 Replies
6754 Views
Avatar
albi

Hi,


I am currently working in an OpenERP (now handled by Bahmni via Odoo), and I want to update the company's address by using queries. 

I am not being able to locate the column  of the res_company model in the openerp database which is linked with the address of the company.


Can anyone suggest me where I can find the structure or model or any diagram which explains models or even better res_company model in particular.


KR,

Albi.

Avatar
Discard
Avatar
Niyas Raphy (Walnut Software Solutions)
Best Answer

Hi,
Activate the developer mode and navigate to Settings -> Technical -> Database Structure -> Models and search and open your model, ie, res.company, then if you open it you can see the details regarding the model like field, access rights, record rules etc.



Non stored computed fields and related fields will not be there in the database table even though they show it in above screen.


Also you have option to connect odoo database frpm pg admin, for this see: Install PgAdmin Configure With Odoo Access, Visualize and Update Data



Thanks



Avatar
Discard
Avatar
albi
Author Best Answer

Thanks Niyas.
(can't reply on your comment since I am a new member)

Avatar
Discard
Related Posts Replies Views Activity
Reuse field from a different Model
models
Avatar
Avatar
1
नव॰ 25
287
How can I use two models in an API (foreign key - relations)?
models
Avatar
0
दिस॰ 24
2260
Import Data From Another Model Solved
models
Avatar
Avatar
1
मार्च 24
3380
Create selection type field dynamically?
openerp
Avatar
Avatar
Avatar
2
सित॰ 23
8564
how can i return a form view from a model method and i just want to show only a specific field instead of all the fields of this model ? Solved
models
Avatar
Avatar
1
जून 23
13544