Skip to Content
Menu
This question has been flagged
1 Odpoveď
1608 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
1280
3
jún 23
12096
1
júl 25
3922
0
mar 25
1081
2
nov 23
2807