Share this page

# DSH_DRILL_TO_PORTLETS

This table stores the information of drill-down portlets.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
DSH_HYPERLINKS | BUILDER_PORTLET_DEF_LINK_ID | BUILDER_PORTLET_DEF_LINK_ID
DSH_PORTLET_DEFS | PORTLET_DEF_ID | DRILL_TO_PORTLET_DEFINITION_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
DRILL_TO_PORTLET_ID | NOT NULLABLE | NUMBER | System identifier for the drill-down portlet
VERSION | NOT NULLABLE | NUMBER | Row version information
DRILL_TO_PORTLET_DEFINITION_ID | NULLABLE | NUMBER | Reference to the portlet definition the drill-down portlet points to.
BUILDER_PORTLET_DEF_LINK_ID | NOT NULLABLE | NUMBER | Portlet definition the drill-down portlet is defined in as a hyperlink.
TITLE | NULLABLE | VARCHAR2(200) | Title of the drill-down portlet
DEFINITION_LANGUAGE | NOT NULLABLE | VARCHAR2(40) | Definition language for the drill-down portlet title. Titles of additional languages can be stored in the DSH_DRILL_TO_PORTLETS_LOC table.
LAYOUT_COLUMN | NOT NULLABLE | NUMBER | Column index (0 based) for the layout of the drill-down portlet.
LAYOUT_ROW | NOT NULLABLE | NUMBER | Row index (0 based) for the layout of the drill-down portlet.
LAYOUT_WIDTH | NOT NULLABLE | NUMBER | Width of the drill-down portlet (0 = default width, 1 or 2)
UUID | NOT NULLABLE | VARCHAR2(255) | System-generated unique identifier of the drill-down portlet.
SEQUENCE | NOT NULLABLE | NUMBER | Sequence of the drill-down portlet when multiple portlets are defined in a drill-down portlet.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
DSH_DRILL_PK | UNIQUE |  | DRILL_TO_PORTLET_ID
DSH_DR_POR_IX1 | NONUNIQUE |  | BUILDER_PORTLET_DEF_LINK_ID
DSH_DR_POR_IX2 | NONUNIQUE |  | DRILL_TO_PORTLET_DEFINITION_ID
DSH_DRILL_PORT_UUID_IX1 | NONUNIQUE |  | UUID

## Sequences

This table uses no sequences.

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: