Skip to Content
This question has been flagged
viewodooV9odoo9
3 Replies
12561 Views
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
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
Related Posts Replies Views Activity
Stock move between two warehouses
odooV8 odooV9 odoo9
Avatar
0
Jul 17
5401
Odoo9 view inheritance
view inheritance odoo9
Avatar
Avatar
2
Jan 17
4067
Unbalanced Entry
unbalanced entry odooV9 odoo9
Avatar
Avatar
1
Feb 16
4777
Holiday approval message in V9 not being sent
odooV9 odoo9 odoo9.0
Avatar
0
Nov 15
4227
Inter-company transactions elimination in consolidation reports odoo9
accounting consolidation odooV9 odoo9
Avatar
Avatar
Avatar
2
May 24
7368