Share this page

# 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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: