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 |