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.
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.
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…
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…
