Is there a way to access open erp sql queries?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Akuntansi
- Inventaris
- PoS
- Project
- MRP
Pertanyaan ini telah diberikan tanda
2
Replies
7776
Tampilan
Is there a way to access open erp sql queries?
Hi,
example sql querie update:
def _execute_query(self, cr,id_object ):
sql ='''update my_table_name
set state= 'failure'
where id = %s
''' % (id_object)
cr.execute(sql)
It is not recommended to type SQL-queries directly from a field and use that to access the DB. Reason is that you can make mistakes and mes sup everything, or worse, you are vulnerable to SQL-injections.
The better way is to make your own modules, with fixed SQL, and optional some input, like the example of Borni DHIFI. Than install that module and use a button or dropdown to let users execute the query and/or fill in the needed variables.
Menikmati diskusi? Jangan hanya membaca, ikuti!
Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!
Daftar
Can you please elaborate your question?