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 […]

Relational Fields in Odoo – CBMS Odoo ERP

Relational Fields provide the option to link the data of one model with the data of another model. In Odoo, relational field types are One2many, Many2one, Many2many. #relationalfields #one2many #many2manyodoo #Odoo #Odoo14 #OdooTechnical #Odoo14Technical An One2many field is a one-way direction of selecting multiple records from a table. For example, a Sales Order can contain […]