Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: BobM on January 05, 2023, 10:12:27 pm

Title: Issue: how reliable is SQL scratch pad?
Post by: BobM on January 05, 2023, 10:12:27 pm

We had the issue where Sparx changed the behavior of the diagram property use alias when available where it displays blanks when nothing is filled in (Why the behavior up to Sparx 16.0 to not use alias when <blank> has been removed (if this is the issue) has not been shared to me)

Per instruction of sparx we fill in the alias of the actors we use our diagrams (which was an issue)
As I want to check the results I have seen sorcery at work:

First I perform a simple query to list all my archimate actors
Result:
(https://i.ibb.co/7zPqXMk/Query1.png)

After clicking an actor (ONE single element) suddenly about half of the types changes to BusinessActor (which does displays in the properties)
(https://i.ibb.co/zbsS5Pm/Query2.png)

I search for Object_Type: BusinessActor and don't find anything
(https://i.ibb.co/vVZcTxq/Query5.png)

I search for Object_Type: Class and find all class elements, so I narrow it down to the correct stereotype
(https://i.ibb.co/9VGK7tJ/Query3.png)

My question: How reliable is the scratchpad sql statement as the above result seem to give impossible values
Are there better (more reliable) methods to get simple select results in order to validate stuff (Preferably in Sparx so without having to log into a SQL management studio)

Title: Re: Issue: how reliable is SQL scratch pad?
Post by: qwerty on January 05, 2023, 11:19:13 pm

The object type is the metatype and mangled through various procedures. It is NOT the stereotype. Only that it is connected to it. The profile defines which metatype a stereotype has.

q.

Title: Re: Issue: how reliable is SQL scratch pad?
Post by: Geert Bellekens on January 06, 2023, 12:28:30 am

EA does some "magic" with things like Object_Type and Note when you use the default column names like trying to show the metatype as set in the MDG based on the real object_type and stereotype.

If you give them an alias, EA will leave those fields alone.

So

Code: [Select]

Select o.object_type as RealObjectType from t_object o
Will give you the actual value found in the database.

Geert

Title: Re: Issue: how reliable is SQL scratch pad?
Post by: BobM on January 06, 2023, 12:47:41 am

Quote from: Geert Bellekens on January 06, 2023, 12:28:30 am

EA does some "magic" with things like Object_Type and Note when you use the default column names like trying to show the metatype as set in the MDG based on the real object_type and stereotype.

If you give them an alias, EA will leave those fields alone.

So

Code: [Select]

Select o.object_type as RealObjectType from t_object o
Will give you the actual value found in the database.

Geert

Thank you,

This is important information to know