Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
2 Replies
6513 Tampilan

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

Avatar
Buang
Jawaban Terbai

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

https://ibb.co/tLpfjWn


Avatar
Buang
Jawaban Terbai
query = """
select * from your_table where id = """+str(self.id)+"""
"""
self.env.cr.execute(query)
data = self.env.cr.fetchone()



Avatar
Buang
Post Terkait Replies Tampilan Aktivitas
1
Sep 21
3629
0
Okt 21
1691
2
Mar 18
10426
3
Des 23
19173
0
Mei 24
1269