Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
Custom Query
Your model contains a great deal of information on both project design and project management, and a major benefit of the Chart feature is providing the facility to search through your model and extract specific aspects of that information using your own SQL Query, within the Chart element.
Access Double-click on Chart element | Chart Details | Source > Custom SQL
Extract Information Using SQL Query
Field/Button |
Action |
See also |
|---|---|---|
panel |
Type in your SQL Query. The Select statement must include the alias Series. For Bar Charts you also have the option of grouping the results using the alias GroupName. For example: Select t_object.Status AS Series, t_object.Author AS GroupName from t_object The field provides the facilities of the Common Code Editor, such as intellisense. |
|
OK |
Click on this button to execute the query, close the dialog and generate the Chart.
|
|
Cancel |
Click on this button to abort the changes and close the dialog.
|
|
Learn more
