Odoo Help

2

1
1 Answer
1
Avatar

Brett Lehrer United States

--Brett Lehrer--

1382
| 5 5 10
Milwaukee, United States
--Brett Lehrer--
Director of IT and open source enthusiast.
Brett Lehrer United States
4/16/15, 8:06 PM

The parent_left and parent_right fields are an implementation of the Nested Set Model concept of relational databases, and not exclusive to stock_location.  There are a number of scenarios where they are used to define nested hierarchy: account_account, product_category, ir_ui_menu, etc.  The idea is that given any one record, the parent_left and parent_right fields can define all of the children, children of children, and so on found under that record, and in O(1) complexity.  SerpentCS has written up a much better explanation of this concept already: http://www.serpentcs.com/serpentcs-openerp-parent_left-parent_right-explained

1 Comment
Anil R. Kesariya (AKE) India
4/16/15, 9:38 PM

Thanks Brett.

Ask a Question
Keep Informed
1 follower(s)
About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register
Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now