Adding Customized Columns in Roadmap Hierarchy

By default, only the Entity Name column is displayed in the roadmap hierarchy. If you want to see more columns or use these columns as filters to search roadmap in the roadmap hierarchy, your administrator should add customized columns.

To add customized columns in the roadmap hierarchy:

  1. Set the parameter ENABLE_ROADMAP_EXT_ATTR to true in the server.conf file.

    By default, the value of this parameter is false.

  2. Define the database view APM_ROADMAP_ENTITY_EXT_ATTR_V to add columns you want to be displayed in the roadmap hierarchy.

    For the definition of this view, see APM_ROADMAP_ENTITY_EXT_ATTR_V

APM_ROADMAP_ENTITY_EXT_ATTR_V

This view stores all the columns displayed in the roadmap hierarchy.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

APM_ROADMAP_ENTITY_HIERARCHY_V

ENTITY_ID

ENTITY_ID

APM_ROADMAP_ENTITY_HIERARCHY_V

ENTITY_TYPE

ENTITY_TYPE

Column Descriptions

Column Name

Null?

Data Type

Description

ENTITY_ID

NOT NULL

VARCHAR

Identifier for entity. The value of this column should be either portfolio ID or request ID.

ENTITY_TYPE

NOT NULL

VARCHAR

Roadmap type of the entity. The value of this column should be either portfolio or request.

ATTR_NAME_A

NULLABLE

VARCHAR

Customized column

ATTR_NAME_B

NULLABLE

VARCHAR

Customized column

ATTR_NAME_C

NULLABLE

VARCHAR

Customized column

Note:  

  • We recommend that you add no more than 3 customized columns for the performance sake.

  • The column names in this table follow the rules as below when they are displayed in the roadmap hierarchy:

    • Only the first letter of each word is capitalized in the roadmap hierarchy.
    • The underline between words is switched into space.

    For example, the column name STATUS_NAME is displayed as Status Name in the roadmap hierarchy.