How do I display a PostgreSQL view (ie: CREATE VIEW AS...) in Odoo as a Tree view? How do I create the Python class for it?

Question

Hi,
I created a view from pgadmin, and now I want to display its as tree type of view.  How can I do it?
Do I need to create a class for that view?
for example:
CREATE VIEW AS book.trans .....

on book.py
class BookTrans(models.Model):
_name = "book.trans"
_columns = {

}

I tried that and use field model="book.trans" on Odoo view xml code but nothing shown (not showing any error also on the screen)....any thing I missed?

Tha

Artem · Accepted Answer

Well, views can be updatable (see https://www.postgresql.org/docs/9.3/static/sql-createview.html)  and I suppose ORM can even work with them as with regular 'Model'.
Odoo's view objects have got a 'model' field so python class should be created.
I think you need to review class Model to ensure your view has got all columns this class requires such as, id, write_uid, create_date, maybe tree view doesn't work without them.
Do you think how to install/uninstall your module? During installation new

Budi Sentosa · Answer

http://odoo-development.readthedocs.io/en/latest/dev/py/postgres-views.html

Adil Akbar · Answer

HI, you can follow following tutorial for this:
https://youtu.be/kwkddYoFQCE [1]
Hope it helps,
Thanks

[1] https://youtu.be/kwkddYoFQCE

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Stock move between two warehouses odooV8 odooV9 odoo9	0 heinäk. 17	5271
Odoo9 view inheritance view inheritance odoo9	2 tammik. 17	3906
Unbalanced Entry unbalanced entry odooV9 odoo9	1 helmik. 16	4628
Holiday approval message in V9 not being sent odooV9 odoo9 odoo9.0	0 marrask. 15	4159
Inter-company transactions elimination in consolidation reports odoo9 accounting consolidation odooV9 odoo9	2 toukok. 24	7138

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!