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.

Question

if record.x_disponibilidad and not record.x_aprobacion:
query = "update x_reg_asignaciones set x_aprobacion = 12550"
self.env.cr [1] .execute(query)

[1] http://self.env.cr

Cybrosys Techno Solutions Pvt.Ltd · 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 o

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
self.env.search_count returns different result from self._cr.execute Ratkaistu python sql	2 helmik. 22	6094
How to solved this SQL error ?? Ratkaistu query sql	1 syysk. 21	3810
Update or modify object field value using self.pool in python Ratkaistu python sql	1 huhtik. 15	23461
Create a new record in another model with a condition in Odoo v8 python records odooV8	2 jouluk. 22	4445
How to print tree_view from sql query in odoo 11 query sql tree_view	0 lokak. 21	1691

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!