Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

Why is pgAdmin not showing Name field for project.project model (v8)

name pgadmin V8 Project

1 Odpowiedz

6418 Widoki

Michael Watchorn

I'm working on an import engine from my old ERP to Odoo. I see that (as for every model) there's a name field for project.project (I see this by viewing the Project edit page in developer mode, and placing my cursor over the Project Name field). Here's what shows:

Field: name
Object: project.project
Type: char
Modifiers: {"required": true}

However when I open the project.project table in pgAdmin there's no name column.

I also linked to the same database tables through Access and encountered the same issue.

Can anyone help me out with this, why don't I see the name field?

Gregor Heger

Najlepsza odpowiedź

Hi Michael,

in v8 project,project is inheriting from account.analytic.account all its fields. You can see it by "_inherits = {'account.analytic.account': "analytic_account_id" }" . The inheritance mechanism that is used there is called delegation inheritance. You can read about that in https://www.odoo.com/documentation/8.0/reference/orm.html under point: "Inheritance and extension".

So when you see the box that shows "Field: name, Object: project.project" then in reality that field is from account.analytic.account. You can look up the name in pgadmin by first checking the id of field analytic_account_id in project.project. By this id you can look up the account,analytic.account record.
In the end, the name field is defined in: addons/analytic/analytic.py at line 175 with: "'name': fields.char('Account/Contract Name', required=True, track_visibility='onchange').

You may ask yourself, why in project view, you see "Project Name" and not Account/Contract Name. This is because in the view definition of project.project, the string is separately set by:
<field name="name" string="Project Name"/>

Michael Watchorn

Autor

Excellent Gregor, Thank you so much! I see exactly what you're describing now. Glad you knew this, it doesn't seem that obvious. Much appreciated - Thanks again!

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Why can't I create a new project from a template project? Rozwiązane templates Odoo V8 Project escalation	1 lip 16	5514
V18: broken test cases of project_enterprise module Project	0 cze 25	674
Inserting records to a table from a dataset pgadmin	0 mar 23	2477
List view Rozwiązane name Listview	1 lut 25	1643
Can i query _ids column data in pgAdmin? query pgadmin	1 lut 24	2079

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!