Level numbering in sql query vs Tpos

[viarellano]

Hi all.

I'm trying to get the Level Numbering through a sql query for elements in EA folder structure in project browser.

The problem is that, when elements are at the first level in the folder,  the Tpos is the same as the level numbering shows in the project browser, but not when elements are in more level resulting as follows:

SCENARIO A
parent_element (level numbering 1) ==> Tpos =1
parent_element (level numbering 2) ==> Tpos =2
parent_element (level numbering 3) ==> Tpos =3

SCENARIO B
parent_element (level numbering 1) ==> Tpos =1
son_element (level numbering 1.1) ==> Tpos =2
sonofson_element (level numbering 1.1.1) ==> Tpos =3

so, how can i get the level numbering by a sql query select in EA as it is showed in Scenario B??

Thanks in advance

Vi.