Blog Archives

SQL Search: Which InformationFlow relationship uses element X

The EA offers the possibility to search for the model element used in an InformationFlow in the Project Browser.

To do this, select the InformationFlow in the diagram and choose Read more ›

Posted in Model Search

Modell-Suche in Package-Branch

The Enterprise Architect model repository is a database. Databases can be easily queried with SQL. This results in a wealth of possibilities. A minor problem is recursions! See this blog article.

The structure in the ProjectBrowser – the model tree – corresponds to a parentID, which is stored in the line of the child. To create a recursive query here, we need recursive SQL, which supports some databases.

Posted in Model Search

Use any number of custom tags during report generation

The report generator allows you to configure any number of custom tags for the entire project. 

Posted in Document Generation, Enterprise Architect, Model Search

Modell-Suche Scripten

Sometimes a question can not be answered with a single SQL query. In order to still use the model search, the search can also be scripted.

We write a script (mySearchScript) and programmatically run through the model. In the script itself we can of course use SQL queries (myQuery). The result of the SQL query can be processed further in the script.

Posted in Enterprise Architect, Model Search

Formatted notes when using SQL in fragment templates

Fragment Template

A fragment template is an RTF template, which can be called from another RTF template. This increases the re-usability of the templates and the flexibility to generate documents.

When the template f…

Posted in Document Generation, Model Search

Show Tagged Values within its own column in model searches

One often asked question is, how to show each tagged value in its own column in model searches.
Tagged Values are stored in the table t_objectproperties. We can now use the table t_object,
in which all model e…

Posted in Model Search

Search - Excluded Packages from RTF Reports

Suchen und Find...
</p srcset=

Posted in Document Generation, Model Search, Tips & Tricks

Verteilen von Suchabfragen im Team

Enterprise Architect speichert die selbstdefinierten Suchabfragen aus “My Searches” (Hauptmenü: EDIT | Search in Model // Ctrl+Alt+A // Toolbar Default Tools: Button Project Search) im Pfad “C:\Users\<username>\AppData\Roaming\Sparx Systems\EA\Search Data” in der Datei “EA_Search.xml” und vergibt für jede Suchabfrage immer eine neue GUID.

Read more ›

Posted in Model Search, Teamwork, Tips & Tricks

Nach Attributen und Assoziationsenden (RollenNamen) suchen

Nach Attributen und Assoziationsenden (Rollen Namen) suchen.

Vor allem in größeren Modellen stelle ich mir oft die Frage, ob es ein bestimmtes Attribut gibt und in welchem Classifier (z. B. Klasse oder Komponente) es vorhanden ist.

Ach Assoziationsenden, also der Rollen Name entspricht eigentlich einem Attribut.

Read more ›

Posted in Model Search

Alle gleichnamigen Elemente eines Paketes finden

Der EA erlaubt es, dass zwei Modellelemente in einem Paket denselben Namen haben.
Nach UML ist dies nicht erlaubt. Aus pragmatischen Gründen ist es aber oft sinnvoll in einem Paket zwei Elemente mit gleichem Namen zu halten.

Möchte man aber herausfinden,

Read more ›

Posted in Model Search