Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hi,
i want change the value of a column in particular table using pgsql query from different .py file example i want execute query of res.partner in main.py which is in web module.how can i do this any idea from you.
Can you help me...
Thanks in advance..
Hi,
In any where you can execute query if you get cursor (cr). So, in web module you can get the cursor using following way.
cr = request.session.cr
cr.execute("update res_partner set column1='value1' ")
I hope it is help to execute query in any where into openerp.
Thanks for you replay @Emipro Technologies i have one more question how to commit the query
cr.commit() thats it.
Again thanks @Emipro Technologies i want to do this update activity while restoring dump how can i do this. any idea
Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !
S'inscrire| Publications associées | Réponses | Vues | Activité | |
|---|---|---|---|---|
|
0
mai 20
|
3524 | ||
|
0
juin 16
|
11520 | ||
|
|
1
avr. 15
|
5942 | ||
|
0
mars 15
|
5184 | ||
|
4
déc. 23
|
37473 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
