Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
Given the product.template table with a line for each of all the products, and the product.pricelist.item table with, for each pricelist version, for each pricelist, a line for each product in that pricelist version.
I have to access in the front-end to ALL information of "that" line in the product.pricelist.item which is referring to "that" product (same product_id) in the product.template table.
Imagine other fields like the price surchage that i have to access for each product and display in the front-end.
I currently implemented a ultra-bad, debug only function in the backend which retrieve the whole product.pricelist.item table, and the frontend makes the join to find out these information.
This is (off course) performance killing and insecure and a real mess.
Do anyone of you know a way to make the join in the backend, serverside, and retrive the information in a form accessible in the front-end with something like product.item.myInformation?
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 platform 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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 6/20/16, 5:35 AM|
|Seen: 405 times|
|Last updated: 6/20/16, 6:25 AM|