Configure CLOB Field Type
You can configure a field ID as CLOB field type, if the data type of column configured in CMN_FIELDS.COLUMN_NAME is CLOB. This field type supports the following advanced conditions:
- Begins with
- Contains
- Does not contains
- Missing
- Exists
To configure the new field ID as CLOB field type, the following configurations are required in the database table CMN_FIELD_CONFIGURATION:
Table 1-27 Configurations for Field Type CLOB
Column | Sample Value | Description |
---|---|---|
ENTERPRISE_ID |
3 |
Current Enterprise ID |
FIELD_TYPE_ID |
19 |
CLOB |
FIELD_ID |
30000000 |
Field ID entered in the table CMN_FIELDS. |
KEY |
NULL |
Enter Key as NULL. |
VALUE |
NULL |
Enter value as NULL. |
Note:
You can also refer to existing field ANALYSIS > Case Narrative > Narrative, (CMN_FIELDS.Field_ID - 203050754) of CLOB field type.
Parent topic: Configure CMN_FIELD_CONFIGURATION Table