Can SQL be used to find the custom sort order of elements inside a package?

[Colin Coates]

Sparx EA usually sorts the elements inside a package alphabetically when displayed in the browser. However, this can be overridden by manually setting a sort order. Can SQL be used to find the custom sort order of elements inside a package in the browser?

Not sure which tables in the repository (if any) might hold this information... I have been looking at t_object, t_xref and others but no luck so far...

[Geert Bellekens]

t_object.Tpos for objects, and t_package.Tpos for packages.

Geert

[qwerty]

The number in these columns can be strange depending on whether you used a manual sorting or not (and depending on the alphabtical sort oprtion). To me it's more like black magic.

q.

[Colin Coates]

Excellent! Thank you very much for your assistance gentlemen!