KNTA_SAVED_SEARCH_FILTERS

This table stores the conditions for the saved searches, one row for each search condition.

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_SAVED_SEARCHES

SAVED_SEARCH_ID

SAVED_SEARCH_ID

Column Descriptions

Column Name

Null?

Data Type

Description

SAVED_SEARCH_FILTER_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

SAVED_SEARCH_ID

NOT NULL

NUMBER

Saved search this filter is for

FILTER_NAME

NOT NULL

VARCHAR2(40)

Name of the filter

FILTER_HIDDEN_VALUE

NOT NULL

VARCHAR2(4000)

Hidden value for the filter

FILTER_VISIBLE_VALUE

NOT NULL

VARCHAR2(4000)

Visible value for the filter

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_SAVED_SEARCH_FILTERS_N1

NONUNIQUE

1

SAVED_SEARCH_ID

KNTA_SAVED_SEARCH_FILTERS_U1

UNIQUE

1

SAVED_SEARCH_FILTER_ID

Sequences

Sequence Name

Sequence Type

KNTA_SAVED_SEARCH_FILTERS_S

SAVED_SEARCH_FILTER_ID