Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Create View based on many table

on 8/23/13, 1:08 PM 1,479 views

Hi, I want to know if it is possible to create a view based on 3 tables in Postgresql for OpenERP. I want to use this view to create a calendar view. I work on Ubuntu. Please,be indulgent for my english. Thanks.


AJ Schrafel Paper Corp

--AJ Schrafel Paper Corp--
| 4 5 8
Bronx, United States
--AJ Schrafel Paper Corp--

Exploring OpenERP for business

AJ Schrafel Paper Corp
On 8/23/13, 1:44 PM

Is possible to create a view based on 3 tables in Postgresql?

Without additional programming? No.

If you create a custom module with a model that references the 3 different tables, Yes.

This is a primer on how to create custom modules, but you are best served contacting an openerp partner to do the coding for you. http://www.ibcscorp.com/application-integration-customization/erp/openerp-2/openerp-custom-module-development-quick-start-guide/

Hi. How can I do this? Thanks.

on 8/23/13, 2:01 PM

added a link

AJ Schrafel Paper Corp
on 8/23/13, 6:11 PM

Ok thanks for your help. I know how to create a custom module, but I would like to know how to create a custom module with a model that references 3 different tables? Thanks.

on 9/4/13, 6:57 AM

Put the references in the columns table.

AJ Schrafel Paper Corp
on 9/9/13, 1:45 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 8/23/13, 1:08 PM
Seen: 1479 times
Last updated: 3/16/15, 8:10 AM