Relationhip matrix order with custom SQL

[Guillaume]

Hello

I have a relationship matrix with a selected package as the target, and a custom SQL in the source
The custom SQL sorts elements by Alias

Code: [Select]

select t_object.ea_guid AS CLASSGUID, t_object.Object_Type as CLASSTYPE, t_object.Name
from t_object
where t_object.Package_ID in (<Search Term>) ORDER BY t_object.Alias
Unfortunately the order in the Matrix does not match results in the Find in Project.

Is it a bug?

[Eve]

I think EA only gets the list of elements from your SQL. There's no attempt to match the order returned from the SQL.

[Guillaume]

Hi Eve,

Thank you for your reply. It could be useful if it's supported it in the future.

[billf62]

I don't know if it's a different in nomenclature, but I'm able to get a sorted list in my relationship matrix by using ORDER BY <column nbr>

Example:

SELECT
   objstart.ea_guid AS CLASSGUID,
   objstart.Object_Type AS CLASSTYPE,
   objstart.Name as [Start Name],
   objstart.Object_Type as [Start Type],
...
 
ORDER BY
   3

Hope this helps

[Eve]

I suspect you'll find that if you sort by a column other than the name it won't work. It's just that EA happens to be sorting by the name anyway.

[HLidstrom]

I would like to propose an matrix improvement. (Irrespective of SQL)

I'd like to see a Don't Sort option, i.e., just list in the order the elements appear in the browser, with child elements indented.


I would also like to see a Frequency Sort option, i.e. the more relationships, the higher up and further to the left for an element. I have found this very useful in another tool.


Thanks,
- Håkan

[Paolo F Cantoni]

I would like to propose an matrix improvement. (Irrespective of SQL)

I'd like to see a Don't Sort option, i.e., just list in the order the elements appear in the browser, with child elements indented.
 would also like to see a Frequency Sort option, i.e. the more relationships, the higher up and further to the left for an element. I have found this very useful in another tool.


Thanks,
- Håkan

Then, Håkan,
You'd better put in a feature request using one of the links at the bottom of the page.  If you do so, there is a theoretical possibility that your request may reach planet Sparx and be considered.  Without it, there is a non-zero, but a vanishingly small, possibility it might be considered.

HTH,
Paolo

[Eve]

I'd like to see a Don't Sort option, i.e., just list in the order the elements appear in the browser, with child elements indented.

Project browser sort is probably the hardest. It depends on a number of user options, explicit re-ordering and dynamic sorting. It's certainly not Don't Sort.

[Modesto Vega]

I'd like to see a Don't Sort option, i.e., just list in the order the elements appear in the browser, with child elements indented.

Project browser sort is probably the hardest. It depends on a number of user options, explicit re-ordering and dynamic sorting. It's certainly not Don't Sort.

Project Browser sort is difficult because of the way it is implemented and the little control we have over it.

In my simple mind, there are 2 types of sorts

• alphabetical (either ascending or descending)
• custom

With regards to the later, it would be great to have a sort order field that can be manually overridden. In other words, it will be nice if the sort order is persisted (it may already be), were visible and editable through the UI, and could be changed using some old fashion typing.

In general, sort in Sparx is a nightmare. For example, if I select Sort Axis on a matrix it sorts the elements in alphabetical (descending order). If I don’t sort a matrix it sorts it in alphabetical ascending order. So, in Sparxian Sort Axis = Alphabetical (descending), go wonder. None of the matrix sorts take into consideration the package names, just the element names. I can keep going on (and sorry for the rant).

Going back to the OPs question, if Sort Axis is disabled Sparx could order elements as per your SQL statement, I am not sure, or revert to alphabetical order.

P.S.: All observations based primarily on v13 but will try with v15 later.