Community mailing list archives

Re: categories: what are parent_left and parent_rigth

redCOR AG, robert rottermann
- 09/11/2015 04:40:24
Thanks Jay,

On 11.09.2015 09:26, Jay Vora wrote:
<blockquote cite="" type="cite">

Please check here.
very interesting,

now I wonder, how are parent_left and parent_rigth set, when a new category record is created.
I see, that whenever I create a new category, the values of the existing ones are adapted.

However greping the source, I did not find the piece of code, where the calculation of the new values is done.
<blockquote cite="" type="cite">


On Fri, Sep 11, 2015 at 12:44 PM, robert rottermann <> wrote:
Hi there,

in my quest to mass import partners I need to generate categories.
This I can to using an sql statement like the following:
statement = "INSERT INTO res_partner_category (id, name, active, parent_id) 
VALUES (DEFAULT, '%s', 't', %s) RETURNING id" % (name, pid)

however, when I look at the database structure of res_partner_category, i find 
that there are the two fields: parent_left and parent_rigth
What are they for?
And more importantly: what values should they have?


Post to:

The Splendid journey of 2 years in Numbers
Jay Vora,
Managing Director,
<img src="" style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
Serpent Consulting Services Pvt. Ltd.
Web :
Mobile : 91 - 9879354457
Twitter: jaynvora
Skype: jaynvora
Blog :

Post to: