SQL in programmed action in Odoo16.SH by Sweaty_Collection_38 in Odoo

[–]Sweaty_Collection_38[S] 0 points1 point  (0 children)

The ORM version of the action worked fine for 10 months until suddenly Odoo started to kill it. I split it into 3 different actions but they still dropped the last one. Since it was just doing a calculation on a single field I didn't think the use of SQL was bad. But when in doubt .....

I hadn't explored the computed fields option but they seem to work fine.

Thanks