Skip to Content
Menu
This question has been flagged
2 Replies
5879 Rodiniai

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

Portretas
Atmesti
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


Portretas
Atmesti
Best Answer
query = """
select * from your_table where id = """+str(self.id)+"""
"""
self.env.cr.execute(query)
data = self.env.cr.fetchone()



Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
1
rugs. 21
2909
0
spal. 21
1691
2
kov. 18
9658
3
gruod. 23
18629
0
geg. 24
906