Skip to Content
This question has been flagged
pythonqueryrecordssql
1 Respondre
2466 Vistes
Avatar
Danny Gonzalez 
Hello, I would like to know how I could execute this query only for one record and not have it executed on the entire table.




if record.x_disponibilidad and not record.x_aprobacion:

      query = "update x_reg_asignaciones set x_aprobacion = 12550"

      self.env.cr.execute(query)

Avatar
Descartar
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

If you want to execute the query only for a specific record and not on the entire table, you can modify the query to include a 'WHERE' clause that filters the records based on some criteria, such as the record ID. Here's how you can do it:

if record.x_disponibilidad and not record.x_aprobacion:

    query = "UPDATE x_reg_asignaciones SET x_aprobacion = 12550 WHERE id = %s"

    self.env.cr.execute(query, (record.id,))

WHERE id = %s filters the records to update based on the ID column matching the ID of the specific record .%s is a placeholder for the record ID.


Hope it helps

Avatar
Descartar
Related Posts Respostes Vistes Activitat
self.env.search_count returns different result from self._cr.execute Solved
python sql
Avatar
Avatar
2
de febr. 22
6100
How to solved this SQL error ?? Solved
query sql
Avatar
Avatar
1
de set. 21
3818
Update or modify object field value using self.pool in python Solved
python sql
Avatar
Avatar
1
d’abr. 15
23472
Create a new record in another model with a condition in Odoo v8
python records odooV8
Avatar
Avatar
Avatar
2
de des. 22
4447
How to print tree_view from sql query in odoo 11
query sql tree_view
Avatar
0
d’oct. 21
1691