Share this page

# KNTA_SAVED_SEARCH_TYPES

This table stores one record for each saved search type supported by PPM Center. This table stores the details of which JSP pages should be used for getting the parameters for the search and displaying the search results.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_ENTITIES_NLS | ENTITY_ID | ENTITY_ID
KNTA_USERS | USER_ID | LAST_UPDATED_BY

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
SAVED_SEARCH_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
ENTITY_ID | NOT NULL | NUMBER | ID of the entity being searched for
SEARCH_JSP | NOT NULL | VARCHAR2(200) | URL for the search page jsp
RESULT_JSP | NOT NULL | VARCHAR2(200) | URL for the result page jsp
SEARCH_TYPE_NAME | NULLABLE | VARCHAR2(80) | Name of the search type

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KNTA_SAVED_SEARCH_TYPES_U1 | UNIQUE | 1 | SAVED_SEARCH_TYPE_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: