Script to sort elements in package by Alias Ref

[Guillaume]

Hi,
Is there any script available that sorts elements by the Alias ?
I guess it requires to update the TPos value via a SQL UPDATE

I imported a number of requirements that I'd like to sort by the reference number, contained in the alias field

thanks

[Geert Bellekens]

You shouldn't go by SQL update, you access the TPos using Element.TreePos

Geert

[Guillaume]

Hi Geert,

This method only works to get the value. It doesn't work when setting a value e.g. element.TreePos = 2 (an error message is displayed), so I used a SQL UPDATE query.

Have you successfully tried it on your end? Something I might be missing?

thanks

[Geert Bellekens]

What is the error message?

Look closely at the documentation. For some reason they decided to use a Long for the Treepos and not an int, so you might get a datatype error when assigning value "2"

Geert

[Guillaume]

Thanks for the advice ; casting to a long worked  

[Guillaume]

FYI I published an article on Sparx Community site with 2 project browser scripts: sort by Alias, and sort by a dedicated tagged value (SortingOrder).

url : http://community.sparxsystems.com/community-resources/798-project-browser-script-sort-by-alias-sort-by-tagged-value