Skip to Content
Menu
This question has been flagged
2 Replies
6430 Zobrazenia

can i use sql query in my automated (user interface) action with odoo?

Avatar
Zrušiť
Best Answer

Yes, if you select "execute python code", you can execute SQL in automated action as shown in an example:

https://ibb.co/tLpfjWn


Avatar
Zrušiť
Best Answer
query = """
select * from your_table where id = """+str(self.id)+"""
"""
self.env.cr.execute(query)
data = self.env.cr.fetchone()



Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
1
sep 21
3549
0
okt 21
1691
2
mar 18
10382
3
dec 23
19114
0
máj 24
1234