How does parent left and parent right working in stock_location,
I was working with multiple warehouse, some how different warehouse was configured in sales and purchase for few records, it suppose to be same, It was causing problem on updating quantity.
I fixed it by applying update queries , I have reset the parent left and right which assigned base functionality but how dose it impact I have no idea.
Does anyone know regarding that concept?
Thanks and regards,
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
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 4/13/15, 6:19 AM|
|Seen: 1380 times|
|Last updated: 4/16/15, 9:36 PM|