Skip to Content
This question has been flagged
viewodooV9odoo9
3 Respostes
13394 Vistes
Avatar
Prihadi Ramadhany

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 put exacts field as view book.trans created from pgadmin ?? -->

    }


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?


Thank you community

Avatar
Descartar
Avatar
Artem
Best 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 table not a view is created.

Avatar
Descartar
Avatar
Budi Sentosa
Best Answer

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

Avatar
Descartar
Avatar
Adil Akbar
Best Answer

HI, you can follow following tutorial for this:

https://youtu.be/kwkddYoFQCE

Hope it helps,

Thanks

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Holiday approval message in V9 not being sent
odooV9 odoo9 odoo9.0
Avatar
1
d’abr. 26
5574
Stock move between two warehouses
odooV8 odooV9 odoo9
Avatar
0
de jul. 17
6431
Odoo9 view inheritance
view inheritance odoo9
Avatar
Avatar
2
de gen. 17
4884
Unbalanced Entry
unbalanced entry odooV9 odoo9
Avatar
Avatar
1
de febr. 16
5613
Inter-company transactions elimination in consolidation reports odoo9
accounting consolidation odooV9 odoo9
Avatar
Avatar
Avatar
2
de maig 24
8324