Перейти к содержимому
Меню
Чтобы взаимодействовать с сообществом, необходимо зарегистрироваться.
Этот вопрос был отмечен
1 Ответить
9523 Представления

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.

Related Posts Ответы Просмотры Активность
3
июл. 24
1962
1
дек. 24
2394
1
окт. 24
1656
0
июл. 24
1093
0
мар. 24
1330