Create Model From Multiple Models In Odoo || Create Model Using Query in Odoo
HTML-код
- Опубликовано: 23 апр 2021
- How to create database table using sql query in odoo. Steps to combine data from multiple models into single model in odoo. How to create database views in Odoo. Create view using query in Odoo. Merge multiple model into single model in Odoo.
Part 1: • Create Model/DB View U...
E-Learning Module: apps.odoo.com/apps/modules/14...
Website: www.odoomates.tech/
Github: github.com/odoomates
Email : odoomates@gmail.com
Facebook: / odoomate
Twitter: / odoomates
Support Us in Ko Fi : ko-fi.com/odoomates Наука
Thank you Niyas . Much Appreciated.
Welcome :) and thanks for all the support
Thank you for explaining this topic. Can you please guide how can we create dynamic model in Odoo 16?
This person is spending a lot of time to give others the possibility to learn. Great job bro. I am not a phyton developer but I learn a lot from your video's. Thank u
Thanks for the supportive feedback brother
Thaank you Niyas, its great super explained lesson, i have no good idea about sql queries but i have understood this lesson, thaank you
Thanks brother :)
Honestly I have learned all the concepts from ur videos and because of which I'm a good odoo developer thank u so much sir 🙏🙏
Happy to know it brother :) wishing you a bright future
@@OdooMates ofcourse sir !🙏🙏 Thank you for replying it means a lot
Fascinating topic. And you cover tough SQL queries in this video. I'm clarifying how it works. And try to do this with 'sales.report' and 'purchase.report' tables. And bump into the problem that I have model purchase.report but no table or view in db. And for me it is magic. Maybe you know the issue with odoon purchase -> model purchase.report.
If you are trying to get value from purchase.report model, as it is already an sql view, Copy the sql query that creates the view and you can change it as per needs
@@OdooMates You help me with the video and comments. Thank you.
Great lesson. then how to add a new "field" in the "model". But the field is not from query and will be filled in manually from odoo view
see: ruclips.net/video/46yecsKX2tw/видео.html
hi current version is Odoo 16.
odoo tools no longer have 'drop' and if i remove this line and _cr
self doesn't have command 'execute'
Great Job guys, fantastic. I'm getting this error "AttributeError: module 'odoo.api' has no attribute 'model_cr' " running this in odoo community 14, any suggestion on how to resolve this? Thanks Mates
Can you show the code that you have added
@@OdooMates I have not added any codes yet, I tried running it straight up like that, while it ran without any issues in v12, I got the above error in v14
for odoo 14: remove this from code @api.model_cr
Can we combine point of sale orders with stock.quant model and show pos_orders quantity and stock available quantity on a single pivot report with out using union through joins is yes you help will be really appreciated?
yes possible using query
@@OdooMates I have used the query using left joins but the figures changes when i apply left join or right join?in which i an really stuck your help will be really appreciated.Thanks
According to the result you need, you have to choose between which join you need, hope you know the difference between the joins in the psql
I will recommend you to understand the working of joins in psql, then decide which join has to be used to get your desired result
@@OdooMates Can we get in touch through which i can share the code may be you can help.Thanks
I got a strange behavior when doing filter or group by :(
What is it 🤔
How can I enable the button to export to excel
It will be coming automatically if you are using Odoo 13 and above
@@OdooMates Awesome. I just tried it in Odoo 14. It works great.
@@guilloutube :)