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