How to Add SQL Constraints in a Model | Odoo Technical Video – CBMS Odoo ERP

In this video we will discuss how to use sql constrains in odoo. SQL constraints are defined through the model attribute _sql_constraints. The latter is assigned to a list of triples of strings (name, sql_definition, message), where name is a valid SQL constraint name, sql_definition is a table_constraint expression, and message is the error message. […]

How to Empty an One2Many Field in Odoo – CBMS Odoo ERP

These are the flags that are used for updating Odoo One2many field. (0, 0, { values }) link to a new record that needs to be created with the given values dictionary (1, ID, { values }) update the linked record with id = ID (write values on it) (2, ID) remove and delete the […]