Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: M. LaPointe on August 08, 2014, 07:46:22 am

Title: Level Numbering in SQL Queries
Post by: M. LaPointe on August 08, 2014, 07:46:22 am

Level Numbering values are not stored in t_object, or other table (that I could find).

Is there a way to calculate Level Numbering when querying the database directly? t_object.ParentID is easy enough to find, but I cannot find anything that suggests tree sequence or level.

t_object.TPos is populated only sporadically, and only when a tree sequence has been user-adjusted.

Title: Re: Level Numbering in SQL Queries
Post by: qwerty on August 08, 2014, 08:35:49 am

The sort order is calculated by some strange algorithm inside EA. You can not pull it from a simple query.

q.

Title: Re: Level Numbering in SQL Queries
Post by: M. LaPointe on August 08, 2014, 11:34:38 pm

Such as I feared. Thanks.

I have copied the level numbers to a tagged value  in the past, I suppose that will remain the path forward.

Title: Re: Level Numbering in SQL Queries
Post by: qwerty on August 09, 2014, 05:29:52 am

At least TVs are stable once you created them and you don't have any silly add-in playing around with them  ;)

q.