Share this page

# DSH_PORTLET_PREFERENCES

This table stores the portlet preferences definitions for portlets and drill-down portlets.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
DSH_DRILL_TO_PORTLETS | DRILL_TO_PORTLET_ID | DRILL_TO_PORTLET_ID
DSH_PORTLETS | PORTLET_ID | PORTLET_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
PORTLET_PREFERENCE_ID | NOT NULLABLE | NUMBER | System identifier for the portlet preference
VERSION | NOT NULLABLE | NUMBER | Row version information
NAME | NOT NULLABLE | VARCHAR2(200) | Preference name identifier
ADVANCED_DEF_PROPERTY | NULLABLE | VARCHAR2(200) | Advanced property info of the preference (for example, ENTITY_INFO)
PORTLET_ID | NOT NULLABLE IF DRILL_TO_PORTLET_ID IS NULL | NUMBER | FK to the portlet to which this preference refers
DRILL_TO_PORTLET_ID (Added in PPM 9.66) | NOT NULLABLE IF PORTLET_ID IS NULL | NUMBER | FK to the drill-down portlet which this preference refers

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
DSH_PREF_PK | UNIQUE |  | PORTLET_PREFERENCE_ID
DSH_POR_PRE_IX1 | NONUNIQUE |  | PORTLET_ID
DSH_POR_PRE_IX2 | NONUNIQUE |  | DRILL_TO_PORTLET_ID

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