Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
Custom Query Fragments
You can create RTF Template Fragments to return data from SQL queries, or from model Scripts. The first step in defining such fragments is to use the Custom Query settings to either enter your SQL Search, or enter a starting point for your model Script.
Access Project | Documentation | Document Template Designer: <template> > Content | File | Document Options > Custom Query
Custom Query Options
Option |
Usage |
See also |
|---|---|---|
Custom SQL |
Click on this radio button to enter an SQL query. You can then add fields within the Custom section of your Template Fragment, to refer to the data returned by the SQL Query.
|
|
Custom Script |
Click on this radio button to display a field in which you specify a model Script; click on the drop-down arrow and select the name of the Script that will be used by your Template Fragment. You can then add fields within the Custom section of your Template Fragment that refer to the data returned by the Script.
|
Notes
| • | Custom Queries and the Custom template section can only be used in Template Fragments; they cannot be used in standard RTF Templates |
| • | Custom Queries can reference the ID of the element or package currently being processed by the RTF Template, using the #OBJECTID# or #PACKAGEID# macros |
Learn more
Learning Center topics
| • | (Alt+F1) | Reporting | RTF Template Fragments | |
| • | Create a SQL based Fragment 1 |
| • | Create a SQL based Fragment 2 |
| • | Create a Script Fragment 1 |
| • | Create a Script Fragment 2 |
