Skip to Content
Dette spørgsmål er blevet anmeldt
viewodooV9odoo9
3 Besvarelser
12363 Visninger
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
Kassér
Avatar
Artem
Bedste svar

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
Kassér
Avatar
Budi Sentosa
Bedste svar

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

Avatar
Kassér
Avatar
Adil Akbar
Bedste svar

HI, you can follow following tutorial for this:

https://youtu.be/kwkddYoFQCE

Hope it helps,

Thanks

Avatar
Kassér
Related Posts Besvarelser Visninger Aktivitet
Stock move between two warehouses
odooV8 odooV9 odoo9
Avatar
0
jul. 17
5268
Odoo9 view inheritance
view inheritance odoo9
Avatar
Avatar
2
jan. 17
3900
Unbalanced Entry
unbalanced entry odooV9 odoo9
Avatar
Avatar
1
feb. 16
4623
Holiday approval message in V9 not being sent
odooV9 odoo9 odoo9.0
Avatar
0
nov. 15
4156
Inter-company transactions elimination in consolidation reports odoo9
accounting consolidation odooV9 odoo9
Avatar
Avatar
Avatar
2
maj 24
7132