How To Execute SQL Queries In Odoo || Query Execution In Odoo

[@johnroygeralde7325]

more power to your vlogs!

[@OdooMates]

Always!

[@jishnukm9511]

Usefull Odoomates

[@OdooMates]

Glad you think so!

[@nadeemkazi2092]

Thanks odoo mates

[@OdooMates]

welcome brother

[@hectorherrera4193]

Excellent... and well explained. Thanks for sharing

[@OdooMates]

Glad it was helpful!

[@WkPowerHack]

How to use domain for xls report with query

[@OdooMates]

you can use apply the domain in where condition along with the query

[@robbeleushuis8024]

Thank's, I have a problem with a string param which contains ' .When the query is executed it give me error: name='Thank's' is there a solution for?

[@OdooMates]

put it inside ""thank's" double inverted coma

[@robbeleushuis8024]

​@@OdooMates I used the function .replace("'", "''") which replaces simple quotes by two simple quotes and it work's, thank's for your help !

[@OdooMates]

❤️❤️❤️

[@ShadHastam]

Thanks

[@OdooMates]

Welcome

[@johnroygeralde7325]

Is it also possible to call a storedproc inside a query?

[@ateeqrao9565]

Hello, I have created a column in the table using sql raw query, The column is now present in the table but odoo orm is not recognizing that column, How can I resolve that?

[@temphelp]

How can i connect external ms-sql server for get data or write ?

[@OdooMates]

Hi we can use pymssql library for this purpose

[@kit-kit-kittty2911]

odoo is third class platform for developers