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:
-
Set the parameter
ENABLE_ROADMAP_EXT_ATTR
totrue
in theserver.conf
file.By default, the value of this parameter is
false
. -
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.