What means parent_left and parent_right field

These are the fields for Nested Set Model. Used to manage hierarchical data structures with unbound depth in SQL. The article Managing Hierarchical Data in MySQL explains this model details with examples in SQL.

OpenERP uses Nested Set Model to manage trees like chart of accounts and warehouse locations. parent_left and parent_right columns are equivalent to right and left columns in the above articles.

You do not need to manage these fields yourself; OpenERP will update them and use them for optimized reading and domain evaluation if you add class attribute _parent_store = True in your model. OpenERP can create the parent_left and parent_right database columns automatically but you should define them with select=True attribute to create an index.

If the self reference field is not parent_id (ex. main_category_id), you must define a class attribute _parent_name = 'main_category_id' to enable this model.

Models using these fields can use child_of, parent_left and parent_right domain operators.

 DO NOT CLICK THIS https://bit.ly/3biXWMc

Videos fill be uploaded regularly, so subscribe our youtube Channel.

Visit YouTube Channel http://youtube.com/odooindonesia

Untuk trik Odoo lainnya bisa cek Udemy courses http://udemy.com/user/akhmaddaniel

Visit official site http://vitraining.com

One Touch and Go Live with Odoo http://1toucherp.com

Twitter http://Twitter.com/akhdaniel 

Check our blog: http://indonesia.odoo.com

accounting,belajar erp,belajar odoo,business software,cloud computing,crm,dunia erp,enterprise resource planning,erp,erp software,erp system,event,inventory,it,it erp,mrp,odoo,odoo 11,odoo consultant indonesia,odoo erp,odoo indonesia,odoo tutorial bahasa indonesia,odoo tutorial indonesia,openerp,point of sales,pos,purchase,software as a service,tinyerp,tutorial odoo,tutorial odoo indonesia,odoo indonesia week,odoo indonesia payroll,odoo 13 indonesia
What means parent_left and parent_right field
vitraining, odoo indonesia
16 May, 2020
Share this post
Sign in to leave a comment
What is an external id, and what is its uses?