Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: Colin Coates on September 06, 2022, 10:54:37 pm

Title: Can SQL be used to find the custom sort order of elements inside a package?
Post by: Colin Coates on September 06, 2022, 10:54:37 pm

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...

Title: Re: Can SQL be used to find the custom sort order of elements inside a package?
Post by: Geert Bellekens on September 07, 2022, 12:07:45 am

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

Geert

Title: Re: Can SQL be used to find the custom sort order of elements inside a package?
Post by: qwerty on September 07, 2022, 07:15:19 am

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.

Title: Re: Can SQL be used to find the custom sort order of elements inside a package?
Post by: Colin Coates on September 07, 2022, 08:04:31 pm

Excellent! Thank you very much for your assistance gentlemen!