This question has been flagged
3 Replies
9795 Views
viewodooV9odoo9
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
Discard
Niyas Raphy (Walnut IT)

Watch: https://www.youtube.com/watch?v=_KIsGo4sttQ

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
Discard
Avatar
Budi Sentosa
Best Answer

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

Avatar
Discard
Avatar
Adil Akbar
Best Answer

HI, you can follow following tutorial for this:

https://youtu.be/kwkddYoFQCE

Hope it helps,

Thanks

Avatar
Discard