Odoo Help

Welcome!

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.

0

Postgresql temporary table

By
zbik
on 10/22/16, 5:12 PM 251 views

Is possible manipulation on postgresql temporary table in odoo?


Presumably, the creation is not a problem, but how to organize views?

I would be grateful for any suggestion or an example.

0
Jaime Vasquez
On 10/23/16, 3:10 PM

In posgresql you can use temporary views and or tables but they are not accessible from Odoo.

Odoo has it's special temporary tables, they are  typically used for wizards.  To use a temporary table you can define it as a normal class, just use the following type of inheritance:  models.TransientModel (new api) or osv.osv_memory (old api).

The views are defined as normal views.


see:
http://findnerd.com/list/view/-How-to-create-an-osv-memory-wizard-systems-in-Odoo-9-/12288/

http://stackoverflow.com/questions/28237145/using-popup-window-to-get-user-inputs-and-use-those-inputs-in-buttons-function


HTH

:)

Thank you for your answer. I'm not interested in wizard with model Transient. I seek solutions with temporary table and access records per session, not per user.

zbik
on 10/24/16, 6:29 AM

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)

Stats

Asked: 10/22/16, 5:12 PM
Seen: 251 times
Last updated: 10/23/16, 3:10 PM