Share this page

# KNTA_PORTLET_TYPES

This table stores information that defines the available portlet types throughout the dashboard.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_PORTLET_COLUMNS | PORTLET_COLUMN_SET_ID | DEFAULT_LAYOUT_SET_ID
KNTA_PERSONALIZATION_VALUES | PERSONALIZATION_VALUE_SET_ID | DEFAULT_PERSON_VALUE_SET_ID
KNTA_USERS | USER_ID | LAST_UPDATED_BY

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
PORTLET_TYPE_ID | NOT NULL | NUMBER | System-generated identifier
CREATION_DATE | NOT NULL | DATE | Date record was created
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
VALID_FROM_DATE | NOT NULL | DATE | Date and time when the portlet definition was changed that would have caused propagation.
PORTLET_TYPE_NAME | NOT NULL | VARCHAR2(80) | Name of the portlet
DESCRIPTION | NULLABLE | VARCHAR2(400) | Description of the portlet.
PORTLET_CATEGORY | NULLABLE | VARCHAR2(80) | User defined category for the portlet
PORTLET_URL | NOT NULL | VARCHAR2(200) | Relative URL location from the dashboard home for a portlet of this type
PORTLET_MAX_URL | NULLABLE | VARCHAR2(200) | Relative URL location from the dashboard home for the max page of a portlet of this type
PORTLET_FILTER_URL | NULLABLE | VARCHAR2(200) | Relative URL location from the dashboard home for the filter page of a portlet of this type
PORTLET_ARRANGE_DATA_URL | NULLABLE | VARCHAR2(200) | Relative URL location from the dashboard home for the arrange data page of a portlet of this type
PRODUCT_SCOPE_TYPE | NOT NULL | VARCHAR2(30) | Defines what product does this portlet belong to
EDITABLE_FLAG | NOT NULL | VARCHAR2(1) | A flag to indicate whether an instance of this portlet type is editable
MAXIMIZABLE_FLAG | NOT NULL | VARCHAR2(1) | A flag to indicate whether an instance of this portlet type is maximizable
SINGLE_INSTANCE_FLAG | NOT NULL | VARCHAR2(1) | A flag to indicate whether only one instance of the portlet type is allowed per user
ENABLED_FLAG | NOT NULL | VARCHAR2(1) | A flat to indicate whether this portlet type is enabled to be instantiated
DISPLAY_CONFIGURABLE_FLAG | NOT NULL | VARCHAR2(1) | Internal field, defines if the portlet columns can be configured in portlet builder
FILTER_CONFIGURABLE_FLAG | NOT NULL | VARCHAR2(1) | Internal field, defines if the portlet filter fields be configured in portlet builder
RESTRICT_ACCESS_FLAG | NOT NULL | VARCHAR2(1) | If the value is Y, the portlet security checks are made.
FILTERABLE_FLAG | NOT NULL | VARCHAR2(1) | Internal field for backwards compatibility. Defines if the portlet data can be filtered.
REQUIRE_PERSONALIZATION_FLAG | NOT NULL | VARCHAR2(1) | Defines if the user should be forced to personalize the portlet (first time only) before viewing the data.
BASE_SELECT_CLAUSE | NULLABLE | CLOB | Default SELECT clause of the query that is used to load the data for this portlet.
BASE_FROM_CLAUSE | NULLABLE | VARCHAR2(4000) | Default FROM clause of the query that is used to load the data for this portlet.
BASE_WHERE_CLAUSE | NULLABLE | CLOB | Default WHERE clause of the query that is used to load the data for this portlet.
BASE_ORDER_BY_CLAUSE | NULLABLE | VARCHAR2(4000) | Default ORDER_BY clause of the query that is used to load the data for this portlet.
BASE_GROUP_BY_CLAUSE | NULLABLE | VARCHAR2(4000) | Default GROUP_BY clause of the query that is used to load the data for this portlet.
BASE_HAVING_CLAUSE | NULLABLE | VARCHAR2(4000) | Default HAVING clause of the query that is used to load the data for this portlet.
DEFAULT_TITLE | NOT NULL | VARCHAR2(80) | Default title given to new instances of this portlet type
DEFAULT_WIDTH | NOT NULL | NUMBER | Default width, narrow or wide, of this portlet type
DEFAULT_MAX_ROWS | NULLABLE | NUMBER | Default maximum number of rows displayed in a portlet of this type
LAYOUT_TYPE_CODE | NOT NULL | VARCHAR2(30) | Layout type, table or form, of this portlet type
DEFAULT_LAYOUT_SET_ID | NULLABLE | NUMBER | ID of the default layout set, usually column set, for this portlet type
DEFAULT_PERSON_VALUE_SET_ID | NULLABLE | NUMBER | ID of the default personalization value set for this portlet type
CLASS_OF_DATA_CAPSULE | NOT NULL | VARCHAR2(200) | Java class of the capsule used by this portlet type
ENTITY_LAST_UPDATE_DATE | NOT NULL | DATE | Date a record in the entity was last updated
SOURCE_TYPE_CODE | NULLABLE | VARCHAR2(30) | For records that have been updated by an interface or migrator, indicates the type of external update (specific interface or migrator name, and so on)
SOURCE | NULLABLE | VARCHAR2(100) | For records that have been updated by an interface or migrator, provides additional information about the source of the external update.
TIMEOUT | NULLABLE | NUMBER | Time in seconds after which the portlet query will be timed out
PARAM_JSP_URL | NULLABLE | VARCHAR2(200) | Parameters that are passed to the Java Server Page URL for the portlet to be displayed properly
CONTROLLER_CLASS | NULLABLE | VARCHAR2(200) | Java controller class for the portlet
DRILL_DOWN_SELECT_CLAUSE | NULLABLE | VARCHAR2(2000) | SQL Select clause for drill down functionality for the portlet
LIMIT_RESULTS_FLAG | NOT NULL | VARCHAR2(1) | Flag that determines if the portlet has a limit on the number of results
PAGEABLE_FLAG | NOT NULL | VARCHAR2(1) | Flag that determines whether the portlet is able to maximize to a full page
DEFAULT_MAX_PAGE_MAX_ROWS | NULLABLE | NUMBER | Default maximum pages and maximum rows for the portlet
USE_BIND_VARIABLES_FLAG | NOT NULL | VARCHAR2(1) | If this flag is set to Yes, the portlet sql will use the bind variables. This makes the sql run faster, in most cases this should be set to Yes. There are cases in which this has to be set to No for the sql to work.
DATA_SOURCE_TYPE_CODE | NOT NULL | VARCHAR2(30) | the type of data source, usually SQL

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KNTA_PORTLET_TYPES_U1 | UNIQUE | 1 | PORTLET_TYPE_ID
KNTA_PORTLET_TYPES_U2 | UNIQUE | 1 | PORTLET_TYPE_NAME

## Sequences

Sequence Name | Sequence Type
--- | ---
KNTA_PORTLET_TYPES_S | PORTLET_TYPE_ID

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: