Level Numbering in SQL Queries

[M. LaPointe]

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.

[qwerty]

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

q.

[M. LaPointe]

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.

[qwerty]

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

q.