Skip to Content
This question has been flagged
actionfunctionserverpostgresqlexecute
1 Respondre
1357 Vistes
Avatar
Danny Gonzalez 
Hello, I would like to know if there is a way from a server action to execute an existing postgresql function in my database


Avatar
Descartar
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hello,

You can execute an existing postgresql function using server actions. 

For that choose the respective server action or create a server action from settings -> Technical -> Server Actions ( it is only available in developer mode). In that server action set the action type to "Execute Python Code". And then write the python code to execute postgresql function. Use self.env.cr.execute() and self.env.cr.fetchone() in the python code.

Hope it helps.

Avatar
Descartar
Related Posts Respostes Vistes Activitat
how to select all blocks on a page?
action function
Avatar
0
de febr. 25
846
difference between server actions and client actions in Odoo? Solved
action server
Avatar
Avatar
Avatar
Avatar
3
de juny 23
10863
When should Database be separated on Separate Server. Solved
server database postgresql
Avatar
Avatar
1
de jul. 25
3341
Sekcja opinii i komentarz
action development function
Avatar
0
de març 25
817
Run server action only on certain products Solved
action server routes
Avatar
Avatar
2
de nov. 23
2416