Skip to Content
Menu
This question has been flagged
1 Odpoveď
1364 Zobrazenia
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
Zrušiť
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
Zrušiť
Related Posts Replies Zobrazenia Aktivita
0
feb 25
847
3
jún 23
10870
1
júl 25
3342
0
mar 25
818
2
nov 23
2418