Share this page

# KNTA_PORTLETS

This table stores a row for each instance of a portlet type. This table stores both seeded rows for default portlets and dynamic rows on demand. The first time a user personalizes a page, edits a portlet on the page, or deletes a portlet from the page, the default rows of the page are duplicated for the user. After that, if the user deletes a portlet, the corresponding row will be deleted. The user will never be able to delete the seeded rows using the application.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KNTA_PERSONALIZATION_VALUES | PERSONALIZATION_VALUE_SET_ID | PERSONALIZATION_VALUE_SET_ID
KNTA_PORTLET_COLUMNS | PORTLET_COLUMN_SET_ID | PORTLET_COLUMN_SET_ID
KNTA_PORTLET_TYPES | PORTLET_TYPE_ID | PORTLET_TYPE_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
PORTLET_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
ENTITY_LAST_UPDATE_DATE | NOT NULL | DATE | Date a record in the entity was last updated
PORTLET_TYPE_ID | NOT NULL | NUMBER | Portlet type of this portlet
USER_PAGE_TAB_ID | NOT NULL | NUMBER | Page and the tab that his portlet belongs to for a user
PARAMETER_SET_CONTEXT_ID | NULLABLE | NUMBER | Parameter set context ID for the filter fields
WIDTH | NOT NULL | NUMBER | Width of this portlet type (1 = narrow or 2 = wide)
TITLE | NOT NULL | VARCHAR2(80) | User-defined title of this portlet
SECTION | NOT NULL | NUMBER | Section number of the page (starting from 1) that this portlet sits on
ROW_IN_SECTION | NOT NULL | NUMBER | Row number in the section (starting from 1) that this portlet sits on
MAX_ROWS | NULLABLE | NUMBER | Maximum number of rows to be displayed. This will be part of the WHERE clause, but we have a separate column for it so that it can be easily changed by consultants, configurators, and so on, either in SQL*Plus or through a screen in a future release.
PERSONALIZATION_VALUE_SET_ID | NULLABLE | NUMBER | Identifies the set of personalization values for this portlet. See table KNTA_PERSONALIZATION_VALUES.
PERSON_VALUE_SET_CHANGED_FLAG | NOT NULL | VARCHAR2(1) | Whether this portlet has be personalized by the user
PORTLET_COLUMN_SET_ID | NULLABLE | NUMBER | If this portlet's type has the layout type "TABLE" this should reference the portlet_column_set_id from KNTA_PORTLET_COLUMNS.
PORTLET_COL_SET_CHANGED_FLAG | NULLABLE | VARCHAR2(1) | Whether the user has personalized the columns in the portlet
SELECT_CLAUSE | NULLABLE | CLOB | SELECT clause of the query that is used to load the data for this portlet
FROM_CLAUSE | NULLABLE | VARCHAR2(4000) | FROM clause of the query that is used to load the data for this portlet
WHERE_CLAUSE | NULLABLE | CLOB | WHERE clause of the query that is used to load the data for this portlet
ORDER_BY_CLAUSE | NULLABLE | VARCHAR2(4000) | ORDER BY clause of the query that is used to load the data for this portlet
GROUP_BY_CLAUSE | NULLABLE | VARCHAR2(4000) | GROUP BY clause of the query that is used to load the data for this portlet
HAVING_CLAUSE | NULLABLE | VARCHAR2(4000) | HAVING clause of the query that is used to load the data for this portlet
INVALID_FLAG | NULLABLE | VARCHAR2(1) | Flag that determines if the portlet is invalid
MAX_PAGE_MAX_ROWS | NULLABLE | NUMBER | Value that determines the maximum pages and maximum rows displayed by the portlet

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KNTA_PORTLETS_N1 | NONUNIQUE | 1 | USER_PAGE_TAB_ID
KNTA_PORTLETS_N2 | NONUNIQUE | 1 | PORTLET_TYPE_ID
KNTA_PORTLETS_U1 | UNIQUE | 1 | PORTLET_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KNTA_PORTLETS_S | PORTLET_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: