Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
2 Replies
6285 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
3358
0
Okt 21
1691
2
Mar 18
10131
3
Des 23
18976
0
Mei 24
1166