Retrieving Items in Project Browser Order

[crd]

Can anyone share with me how to retrieve the information for a package in Project Browser order?  I need to be able to retrieve this information using either the EA API or SQL.

I currently have Level Numbering on for a Package.  I want to be able to retrieve the information as it appears in the Project Browser.

Finally, I can't seem to find where the Level Numbers are stored in the EA tables.  Are they stored?  If so where?

Thanks for any help.
Carol

[Michael Proske]

I think the column you search for is called TPos in the t_object table.  

[Geert Bellekens]

The level number could be a derived property that is not stored in the database.
I guess you'll have to recalculate it yourself then.

Geert

[beginner]

The order in the project browser is a complicated mixture of tree_pos/t_pos, type and alphabetic sorting. I have my boiler plate code in Perl to get it right where needed. Took me quite some time to figure it out.

b.