Sort tables in alphabetical order in diagram

[Timobkr]

I have quite a number of classes listed in the tree and I would like to generate a diagram of these tables sorted alphabetically.
This seems so obvious that I must be missing something. But I have searched the interface all-over

[Geert Bellekens]

There is nothing obvious about that at all.
I've never had that need, nor did I ever hear about something like that.

Maybe you should look into using the list view instead of a the diagram view.
Different tools for different goals.

Geert

[Paolo F Cantoni]

Have you tried the "Layout Tools"?  We use them to generate alpha sorted lists of items in a folder.

HTH,
Paolo

[MichaelJ]

I have quite a number of classes listed in the tree and I would like to generate a diagram of these tables sorted alphabetically.
This seems so obvious that I must be missing something. But I have searched the interface all-over

Hi,
There are a few options that you could try:

• Use the "Box" layout found in the "Diagram Layout" panel and select the "Name (ascending)" for the Sort By option
• Create a script that sorts the list of classes. You can reference this script either as a runtime script (right-click diagram, [Specialize]->[Scripts]->[xxxxx]) or in your report template
• Manually move each element around the diagram until they are "sorted"
• Right-click the diagram and select [Switch View]->[list View]. Then click on the "Name" column to sort

However, my preference is the "Box" layout approach. Simple and quick enough. :-)

[/list]

[Timobkr]

Hello everyone,
MichaelIJ, your solution number 1 seems ideal.
> Use the "Box" layout found in the "Diagram Layout" panel and select the "Name (ascending)" for the Sort By option
However, I can't find the sort by ascending functionality. Could you tell me where to find it ?
Kind regards,
Timothée

[qwerty]

In V15 you need to open the Layout Tools window. This is not present in V13.5 (not checked V14).

q.

[MichaelJ]

...However, I can't find the sort by ascending functionality. Could you tell me where to find it ?...

Sure.

• Click on "Layout" in the Ribbon
• Select "Diagram Layout" in "Tools" section
• Click "Open Diagram Layout Tools" (the Diagram Layout tool window opens)
• (in the diagram Layout Tool window) Select "Box" from the drop down list
• Select "Name (Ascending)" from the "Sort By" drop down list

[Timobkr]

Thanks MichaelIJ!
That works, as I am on v15.1.
Most tables are sorted correctly. However there are a few misteries.
The first class is called CLASSEMENT
Then there is a series of classes with names starting with the word JARDINS (JARDINS_ACCES_..., JARDINS_CATEGORIE_..., etc).
Then another series starting with the characters dvMonu_ (dvMonu_Categorie1, dvMonu_Categorie2, ..., dvMonu_ValeurSite, dvMonu_actualite, dvMonu_note)

So here's the list omitting many items which are correctly sorted :

CLASSEMENT
JARDINS_ACCES_ICOMOS
JARDINS_CATEGORIE_ICOMOS
...
dvMonu_Categorie1
dvMonu_Categorie2
...
dvMonu_TypeThematique
dvMonu_ValeurSite
dvMonu_actualite
dvMonu_note

Any idea why
- J comes before d?
- a of actualite comes before C of Categorie or V of ValeurSite.

APPARENTLY, uppercase and lowercase are sorted separately.
Is there any way to configure EA not to do that?
I see I'm not the only one to wish for a case insensitive sorting.
https://sparxsystems.com/forums/smf/index.php?topic=29124.0
Has this been implemented? I haven't found it yet.
Thanks again to all of you!

[qwerty]

It's the collation set in your database. Ask your DBA.

q.

[MichaelJ]

...Any idea why
- J comes before d?
- a of actualite comes before C of Categorie or V of ValeurSite.
...

Definitely, the reason for this strange behavior is (as you correctly identified) CASE-SENSITIVE. For example, if "dvMonu_Categorie1" was cased as "DVMONUE_CATEGORIE1", then the Box layout will order the items correctly as you expect. BUT... because "dvMonu_Categorie1" is lowercase, it is sorted after the uppercase "JARDINS_...."

I am not aware of a way to enable case-insensitive sorting. I believe you might need to utilise custom diagram scripts to achieve this.