Skip to Content
Menú
This question has been flagged
2 Respostes
2736 Vistes

Hello, Recently I noticed that there is a _parent_store attribute in a product.category, I checked in odoo, but didn't get the exact idea why it is used. Can anybody help me to understand what the _parent_store attribute actually does? Thank you in advance :)

Avatar
Descartar
Best Answer

Parent-child tree relationships are represented using a many-to-one relationship with the same model, where each record holds a reference to its parent. The inverse one-to-many relationship represents the record's direct children.

product.category model uses hierarchical data structures (parent-child relationships), Optimize hierarchy tree searching can be enabled by setting the _parent_store=True model attribute and adding the parent_path helper field. This helper field stores additional information about the hierarchy tree structure, which is used to run faster queries

Note: the parent_path field must also be added, and it must be indexed.

Avatar
Descartar
Autor

Thank you Waleed Ali Mohsen, Now I am getting what the _parent_store is! This explanation saves a lot of my time.

Best Answer

Hi Jay,

It is a Nested set of model.It manage hierarchical data structures with unbound depth in SQL. The article Managing Hierarchical Data in MySQL .

_parent_store to False should be sufficient as a workaround for an existing database. The framework can handle child_of operator on models where _parent_store is False, it will simply do multiple queries for traversing the hierarchy. Only the parent_id column is required for child_of.

Regards

Avatar
Descartar
Autor

So basically, It just simply used to optimize the backend performance by reducing no. of queries

Related Posts Respostes Vistes Activitat
0
de jul. 25
1354
2
de nov. 24
6062
2
d’oct. 24
3076
2
d’ag. 24
1801
3
de jul. 24
8160