Skip to Content
Menu
Dette spørgsmål er blevet anmeldt
2 Besvarelser
5751 Visninger

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

Avatar
Kassér
Bedste svar

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

https://ibb.co/tLpfjWn


Avatar
Kassér
Bedste svar
query = """
select * from your_table where id = """+str(self.id)+"""
"""
self.env.cr.execute(query)
data = self.env.cr.fetchone()



Avatar
Kassér
Related Posts Besvarelser Visninger Aktivitet
1
sep. 21
2787
0
okt. 21
1691
2
mar. 18
9559
3
dec. 23
18535
0
maj 24
832