Skip to main content

Get help for ARIS Architect

Identify model types used

You can use this query to identify which model types are used in the database. You then assign the Boolean attribute to these model types.

Procedure. Procedure

  1. Click New New > Query Query. The Query Wizard opens.

  2. Select the database for which you want to define the query and, if necessary, log in using the relevant method filter. The Query 1 tab opens.

  3. Click Ad hoc analysis Query in the bar panel if the bar is not activated yet.

  4. In the Start field, enter the word Database for the item.

    A list of suggestions is displayed during input. Click Database (ARISROOT). This defines the database as the start point for the query.

    In the Successors box all of the possible successors for the start item are listed in a bulleted list. You can Right arrow expand and Down arrow collapse the bullets.

  5. Click contains > Model in the list. The successor is added to the query.

  6. Click Create table view Create table view in the Start tab bar. The Table 1 tab is created in the Output Output bar.

  7. Click Template below the table.

  8. On the Definition tab, select the Model query item and drag it into the cell A1.

  9. Click in cell B1.

  10. Click Formula Formulas > Insert formula in the Data tab bar. The dialog opens.

  11. Double-click the formula QUERY_ITEM_TYPE. The following expression is displayed for the cell:

    =QUERY_ITEM_TYPE(

  12. Complete the expression by adding A1).

  13. Click Result below the table.

  14. Click Start simulation run Start query on the Query tab bar.

All models and their model types are displayed.