跳至內容
選單
此問題已被標幟
1 回覆
9548 瀏覽次數

Hello everybody,

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,

Anil.





頭像
捨棄
最佳答案

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

頭像
捨棄
作者

Thanks Brett.

相關帖文 回覆 瀏覽次數 活動
3
7月 24
1977
1
12月 24
2427
1
10月 24
1661
0
7月 24
1096
0
3月 24
1339