Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
2 Replies
5719 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
2735
0
Okt 21
1691
2
Mar 18
9523
3
Des 23
18510
0
Mei 24
814