Skip to Content
This question has been flagged
modelsopenerp
2 Replies
4931 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 IT)
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
How can I use two models in an API (foreign key - relations)?
models
Avatar
0
Dec 24
38
Import Data From Another Model Solved
models
Avatar
Avatar
1
Mar 24
839
Create selection type field dynamically?
openerp
Avatar
Avatar
Avatar
2
Sep 23
6394
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
Jun 23
10731
How to hide the create button dynamical tree view in openerp ? Solved
openerp
Avatar
Avatar
2
Mar 23
44270