Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: crd on April 22, 2010, 04:14:41 am

Title: Retrieving Items in Project Browser Order
Post by: crd on April 22, 2010, 04:14:41 am

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

Title: Re: Retrieving Items in Project Browser Order
Post by: Michael Proske on April 22, 2010, 05:40:31 am

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

Title: Re: Retrieving Items in Project Browser Order
Post by: Geert Bellekens on April 22, 2010, 04:37:56 pm

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

Title: Re: Retrieving Items in Project Browser Order
Post by: beginner on April 22, 2010, 07:04:03 pm

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.