KNTA_STORED_QUERY_DETAILS

This table stores workbench query definitions saved by users. A stored query is specific to a particular user and a particular workbench. The particular workbench determines the significance of this particular query definition.

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_PARAM_SET_FIELDS_NLS

PARAMETER_SET_FIELD_ID

MAX_PARAMETER_SET_FIELD_ID

KNTA_PARAMETER_SETS_NLS

PARAMETER_SET_ID

PARAMETER_SET_ID

KNTA_STORED_QUERIES

QUERY_ID

QUERY_ID

KNTA_VALIDATIONS_NLS

VALIDATION_ID

VALIDATION_ID

Column Descriptions

Column Name

Null?

Data Type

Description

QUERY_DETAIL_ID

NOT NULL

NUMBER

System-generated identifier

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

QUERY_ID

NOT NULL

NUMBER

Identifier for the parent query.

MAX_PARAMETER_SET_FIELD_ID

NOT NULL

NUMBER

Identifier for the knta_parameter_set_fields that this record will query.

PROMPT

NOT NULL

VARCHAR2(80)

Field prompt that the users see in the specific form.

VALIDATION_ID

NOT NULL

NUMBER

Identifier for the validation that validates this field.

TOKEN

NOT NULL

VARCHAR2(40)

This is the token field that this record represents

PARAMETER_SET_ID

NOT NULL

NUMBER

Identifier for the knta_parameter_sets, indicates the type of parameter this record represents

CONDITION_CODE

NOT NULL

VARCHAR2(30)

Lookup code for the lookup type IS_QUERY_CONDITIONS

VISIBLE_VALUE

NULLABLE

VARCHAR2(2000)

This field represents the value that the user sees. For a workflow field they'll see the workflow name

HIDDEN_VALUE

NULLABLE

VARCHAR2(2000)

This field represents the value that represents an identifier of the specified field. For a workflow field this column should contain the workflow ID

MULTI_LIST_FLAG

NOT NULL

VARCHAR2(1)

Indicates that this field is a multi list autocomplete field

ENABLED_FLAG

NOT NULL

VARCHAR2(1)

Indicates that the current record is included in the construction of an advance query

CONVERTED_COMPONENT_TYPE_CODE

NOT NULL

VARCHAR2(30)

Lookup code for the lookup type COMPONENT_TYPE, this is a converted component_type

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_STORED_QUERY_DETAILS_N1

NONUNIQUE

1

QUERY_ID

KNTA_STORED_QUERY_DETAILS_U1

UNIQUE

1

QUERY_DETAIL_ID

Sequences

Sequence Name

Sequence Type

KNTA_STORED_QUERY_DETAILS_S

QUERY_DETAIL_ID