Define a Model View Chart

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 capture, summarize and present that information in the form of a Model View table that you can operate on both as a single element and as a list of selectable items. On one diagram you can put a number of Model View elements reporting on different aspects of the model, to create a tailored automatic status review of your project.

For a Model View Chart, the type is defined in the template and the content is defined in the SQL Query that you create as the data source. After you generate the Chart, you can perform a number of operations on the data it displays.

Access Double-click on Chart element (opens directly to Chart Details | Source > Custom SQL)

Right-click on Chart element | Edit List View

Specify Content



See also

data panel

Type in the SQL Query to define what type of data to extract from the model, and what structures in the model to extract it from. For example:

     SELECT t_object.Name, t_object.Status, t_object.Author FROM t_object WHERE t_object.Object_Type = 'Change'

This Query returns a list of Change elements, showing the element name, status and author. Column names will display as returned by the database (unless you are using a translated edition of the system, in which case translations might be automatically applied).  Columns can also be aliased by appending AS '<column name>' after the column reference.

You can also use #<macro>#s as string replacers, as for other SQL Search Queries.

Create Search Definitions


Click on this button to close the dialog and generate the Chart.


Click on this button to abort the changes and close the dialog.

Edit Chart Entries

Having created the Model View Chart, you can drag the borders of the element to a suitable display size, manipulate the display as for other Search views, and work on individual entries through the context menu.

Context Menu Option


See also

Exit Edit Mode

Close the Chart as a list of accessible entries and revert to the Chart as a single element.


Open the 'Properties' dialog for the selected item in the Model View.

Copy Selected to Clipboard

Copy the selected item to the clipboard.


Display options to generate a report on the selected item or items, either as:

  • One report on all selected items, or
  • A separate report for each of the selected items

In either case, the 'Generate Documentation' dialog displays. If you have selected to generate separate reports, the 'Generate Documentation' dialog displays separately for each report in turn.

Generate Documentation

Create (Edit/Delete) Linked Document

Open the Linked Document Editor to create (or edit) a linked document on the selected item.


Delete the existing linked document on the item.

Find in Diagrams

Locate the selected item in any diagrams in which it is used.

If the item is only used in one diagram, the display switches to that diagram with the item highlighted on that diagram.

If the item is not used in any other diagram, or is used in more than one diagram, the 'Element Usage' dialog displays.

Show Element Use

Find in Project Browser

Locate and highlight the selected item in the Project Browser.


  • As long as the SQL Query contains the alias ea_guid AS CLASSGUID, you can also drag items out of the list and drop them onto the diagram containing the Chart element, in the same way as you would from the Project Browser

Learn more