{"id":250616,"date":"2022-08-05T07:54:47","date_gmt":"2022-08-05T07:54:47","guid":{"rendered":"https:\/\/webkul.com\/blog\/?p=250616"},"modified":"2022-08-05T07:57:00","modified_gmt":"2022-08-05T07:57:00","slug":"odoo-fields","status":"publish","type":"post","link":"https:\/\/webkul.com\/blog\/odoo-fields\/","title":{"rendered":"ORM API: Odoo Fields"},"content":{"rendered":"\n

Odoo<\/strong><\/span><\/code> is basically a web-based open source & modular-based framework\/software which include multiple business solutions like \u201cCRM\u201d, \u201cPOS\u201d, \u201cE-Commerce\u201d, \u201cERP\u201d, \u201cManufacturing\u201d, \u201cInventory Management\u201d, \u201cBilling & Accounting\u201d and \u201cProject Management\u201d. <\/p>\n\n\n\n

Also it follows the ORM structure.<\/p>\n\n\n\n

In our last blog we studied how to create a new module in Odoo<\/a>.<\/p>\n\n\n\n

As we mentioned above, Odoo follows the ORM(\u201cObject Relational Mapping<\/strong>\u201d) structure which manipulates data from the database into Object-Oriented form. <\/p>\n\n\n\n

Classes are represented as tables and fields are represented as columns in Odoo.<\/p>\n\n\n\n

So in this article we will talk about Odoo fields.<\/p>\n\n\n\n

What is the Odoo field?<\/h2>\n\n\n\n

Odoo is a modular based framework.<\/p>\n\n\n\n

So everything is managed by modules and classes.<\/p>\n\n\n\n

Odoo Fields are managed by field class<\/a>.<\/p>\n\n\n\n

Attributes of Odoo Fields<\/h2>\n\n\n\n
  1. string:<\/strong> It represents the label of Odoo fields eg: string=” Webkul”<\/li>
  2. help<\/strong>: It represents the description of Odoo fields eg: help=\u201d This is Webkul type field\u201d<\/li>
  3. readonly<\/strong>: If true then the Odoo fields not editable eg: readonly=True\/False<\/li>
  4. invisible<\/strong>: If true then the Odoo fields not visible to the user eg: invisible=True\/False<\/li>
  5. required<\/strong>: If true then the Odoo fields compulsory for the user eg: required=True\/False<\/li>
  6. copy<\/strong>: If true then the record will be copied if any record is duplicate eg: copy=True\/False<\/li>
  7. index<\/strong>: If true then the field is indexed in database eg: <\/strong>index=True\/False<\/li>
  8. store:<\/strong> If true then the field is stored in the database(For computed\/related fields only) eg: <\/strong>store=True\/False<\/li>
  9. d<\/mark>efault<\/strong>: It<\/mark> is used to set the value of the field, If a value is passed inside this attribute then during record create that value will be set inside the record.<\/li>
  10. group<\/strong>: If the comma-separated list of groups XML ids passed then it will restrict the users of these groups to access these fields.<\/li><\/ol>\n\n\n\n

    And there are many other attributes which are present with the Odoo fields.<\/p>\n\n\n\n

    Where are these fields stored in Odoo?<\/h2>\n\n\n\n

    In Odoo fields<\/strong> are also stored in an object form. All the fields of Odoo are stored inside the \u201cir.model.fields<\/strong><\/a>\u201d and you can also find the list of fields associated with the models which are also present as records in Odoo inside the \u201cir.model<\/strong><\/a>\u201d model.<\/p>\n\n\n\n

    How many types of fields in Odoo?<\/h2>\n\n\n\n

    In Odoo data is stored in the simple, relational, and computed form.<\/p>\n\n\n\n

    Currently, in Odoo, there are three major types of fields which are given below,<\/p>\n\n\n\n

    Basic Fields<\/h3>\n\n\n\n

    It contains the fields which are stored in the simplified form.<\/p>\n\n\n\n

    Boolean<\/h4>\n\n\n\n

    This field stores value in 0\/1(False\/True) and represented by class Boolean<\/strong><\/a>.<\/p>\n\n\n\n

    If false then it stores 0 and if true then value will be 1.<\/p>\n\n\n\n

    eg:<\/strong> field_name = fields.Boolean<\/strong>(string=\u201dField Label\u201d)<\/span><\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    Character<\/h4>\n\n\n\n

    This field stores value in string form and represented by class Char<\/strong><\/a>.<\/p>\n\n\n\n

    eg:<\/strong> field_name = fields.Char<\/strong>(string=\u201dField Label\u201d)<\/span><\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    Integer<\/h4>\n\n\n\n

    This field stores value in numeric form and represented by class Integer<\/strong><\/a>.<\/p>\n\n\n\n

    eg:<\/strong> field_name = fields.Integer<\/strong>(string=\u201dField Label\u201d)<\/code><\/span><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    Float<\/h4>\n\n\n\n

    This field stores value in decimal form and represented by class Float<\/strong><\/a>.<\/p>\n\n\n\n

    eg:<\/strong> field_name = fields.Float<\/strong>(string=\u201dField Label\u201d)<\/span><\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    Advanced Fields<\/h3>\n\n\n\n

    Presentable<\/h4>\n\n\n\n

    Binary<\/h5>\n\n\n\n

    This field stores value in binary form.<\/p>\n\n\n\n

    It store the attachments like file, images, musical files, etc, and represented by class Binary<\/strong><\/a>.<\/p>\n\n\n\n

    eg:<\/strong> field_name = fields.Binary<\/strong>(string=\u201dField Label\u201d)<\/span><\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    HTML<\/h5>\n\n\n\n

    This field stores value in string form and it is used to present the data in html form. HTML field is represented by class HTML<\/strong><\/a>. Parameters like sanitize, sanitize_tags, sanitize_style<\/strong> etc, are used inside the html fields,<\/p>\n\n\n\n

    eg:<\/strong> field_name = fields.HTML<\/strong>(string=\u201dField Label\u201d)<\/code><\/span><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    Image<\/h5>\n\n\n\n

    This field stores value in binary form and used to present the data in image form. The image field is inherited by binary class and represented by class Image<\/strong><\/a>. Parameters like max_width, max_height<\/strong> etc, are used inside the image fields,<\/p>\n\n\n\n

    eg:<\/strong> field_name = fields.Image<\/strong>(string=\u201dField Label\u201d)<\/span><\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    Monetary<\/h5>\n\n\n\n

    This field stores value in decimal form and used to present the money along with the currency and represented by class Monetary<\/strong><\/a>. Parameters currency field(<\/strong>a many2one field of res.currency object<\/em>)<\/strong> etc and used inside the monetary fields,<\/p>\n\n\n\n

    eg:<\/strong> field_name = fields.Monetary<\/strong>(string=\u201dField Label\u201d)<\/code><\/span><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    Selection<\/h5>\n\n\n\n

    This field stores value in string form and this field helps to provide the selection to the user. Selection field is represented by class Selection<\/strong><\/a>. It uses the below attribute to represent the selection to the user,<\/p>\n\n\n\n