Share this page

# DSH_PORTLETS

This table stores information of all the portlets.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
DSH_PORTLET_DEFS | PORTLET_DEF_ID | PORTLET_DEF_ID
DSH_PAGES | PAGE_ID | PAGE_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
PORTLET_ID | NOT NULL | NUMBER | System-generated identifier
VERSION | NOT NULL | NUMBER | Version for the portlet
PORTLET_DEF_ID | NOT NULL | NUMBER | Portlet definition ID
PAGE_ID | NOT NULL | NUMBER | Page ID. A portlet can only be associated with, and therefore, displayed on one page.
LAYOUT_WIDTH | NOT NULL | NUMBER | The width (for columns) of the portlet when it appears on its page with other portlets in a layout. For now, only the values 1 and 2 are supported with 1=short and 2=wide.
LAYOUT_COLUMN | NOT NULL | NUMBER | The zero-based column of the portlet when it appears on its page with other portlets in a layout. For now, only the values 0 and 1 are supported, with 0= the first column and 1= the second column.
LAYOUT_ROW | NOT NULL | NUMBER | The zero-based row of the portlet when it appears on its page with other portlets in a layout.
TITLE | NOT NULL | VARCHAR2 (200) | The string name of the portlet.
IS_MINIMIZED | NOT NULL | CHAR (1) | Flag to indicate whether the portlet is minimized into a bar, rather than displaying its content.
HAS_CHANGED_SINCE_VIEW | NOT NULL | CHAR (1) | Flg to indicate whether the portlet was created or modified by the module distribution process. Once the owner views the portlet for the first time, the flat is set back to `false`. This flag is deprecated.
LAST_UPDATE_DATE | NULLABLE | DATE | Date when the record was last updated
TOUCH | NULLABLE | VARCHAR2 (1) | A meaningless scratch column. Its value is never used for any functional purpose. We just change it to force the page object's version to increment.
IS_PORTLET_COMM | NOT NULL | CHAR (1) | Flag to indicate whether the portlet communication is enabled for this portlet.
UUID | NOT NULL | VARCHAR2 (255) | Universally unique identifier
IS_PAGE_FILTERS_ENABLED | NOT NULL | CHAR (1) | Flag to indicate whether page filters are enabled for this portlet.
BORDERLESS | NOT NULL | CHAR (1) | True if this portlet is presented without a border.
DEFINITION_LANGUAGE | NOT NULL | VARCHAR2 (40) | The language definition for MLU
SHOW_TOTAL_ROW_COUNT | NOT NULL | CHAR (1) | Flag to indicate whether this portlet shows total row count.
EXPORT_TO_HTML_EXCEL | NOT NULL | CHAR (1) | Flag to indicate whether this portlet is exported to HTML format Excel.
LAYOUT | NULL | VARCHAR(4000) | Stores portlet layout information to support more layouts of portlets.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
DSH_PORTLETS_PK | UNIQUE | 1 | PORTLET_ID
DSH_PORT_IX1 | NON-UNIQUE | 1 | PORTLET_DEF_ID
DSH_PORT_IX2 | NON-UNIQUE | 1 | PAGE_ID
DSH_PORT_IX3 | NON-UNIQUE | 1 | UUID

## Sequences

This table does not have any 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: