Where is the class stereotype?

[Modesto Vega]

Where is the class stereotype? Is there a class stereotype? I am just looking at a list of elements in EA with a blank stereotype when I would have expected the stereotype to be class.

[Geert Bellekens]

There shouldn't be.
"Class" is a metatype, so defining a stereotype with the same name would be redundant.

Geert

[Modesto Vega]

I suspected this was the answer. Let me ask the question in a different way, if I want to write a query to get into a ModelView the list of evert element that is a class -  i.e., has a blank stereotype - how do I write my WHERE clause below

SELECT t_object.ea_guid AS CLASSGUID, t_object.Object_Type AS CLASSTYPE, t_object.Name, t_object.Status, t_object.Stereotype, t_object.Author
FROM t_object  ORDER BY t_object.Name
WHERE .......

[qwerty]

Stereotype IS NULL or Stereotype = ""

I guess.

q.

[Geert Bellekens]

Stereotype IS NULL or Stereotype = ""

I guess.

q.

And if you only want Classes and not other element types you use

Code: [Select]

WHERE (Stereotype IS NULL OR Stereotype = '')
AND Type = 'Class'
ORDER BY...
Geert

[Modesto Vega]

WHERE (Stereotype IS NULL OR Stereotype = '')
AND Type = 'Class'
ORDER BY...[/code]

Geert

This what I am looking for but the query returns duplicates, just looking into why this the case.

[Modesto Vega]

To eliminate the duplicates I would need to add to the WHERE clause a condition that filters the current package. There are multiple packages in the project containing different baselines and the query should be specific to each baseline and not global.

[Geert Bellekens]

In the model search you can use

Code: [Select]

and packageID = #Package#to select elements form the package selected in the project browser.

In case you want to query something that is in the selected package, or one of it subpackages recursively you can use

Code: [Select]

and packageID in (#Branch#)
Geert

[Modesto Vega]

In the model search you can use

Code: [Select]

and packageID = #Package#to select elements form the package selected in the project browser.

In case you want to query something that is in the selected package, or one of it subpackages recursively you can use

Code: [Select]

and packageID in (#Branch#)
Geert

Do I need to replace #Package# and #Branch# with anything? Or,  are they parameters?

[Geert Bellekens]

Those are Macros.
EA will replace the #Package# macro with the packageID and #Branch# macro with a comma separated list of all packageID's in the current branch.

See http://sparxsystems.com/enterprise_architect_user_guide/12.1/building_models/creating_filters.html for more info.

Geert

[Modesto Vega]

Of course nothing is that simple with EA, the following query results on an error

Code: [Select]

SELECT t_object.ea_guid AS CLASSGUID, t_object.Object_Type AS CLASSTYPE, t_object.Name, t_object.Status, t_object.Stereotype, t_object.Author FROM t_object
WHERE t_object.Package_ID = #Package# AND t_object.Object_Type = 'Class' AND Stereotype IS NULL ORDER BY t_object.Name
The error is Invalid column name '#Package#'.

P.S.: I am running version 12.0.

[qwerty]

You can not run that in the SQL pad. You need to make a new search to run the #-tags.

For test purposes you need to replace it with a valid package_id.

q.

[Modesto Vega]

The query is meant to go on a Model View element and not in a search. The error happens on the Model View on version 12.0.

The query runs fine as a search but I do not want it there.

[Geert Bellekens]

That's really sad It works as search, but if you select the search as modelview it doesn't work anymore?

If that is the case I would consider it as a bug.

Geert

[Modesto Vega]

I will report it as bug in 12.0, pity I cannot upgrade to 12.1, my 12 "month subscription" run out recently and no longer have access to registered users area.

See http://sparxsystems.com/forums/smf/index.php/topic,30194.0.html.