Configure CMN_FIELDS Table
You can configure the advance condition extensibility columns for the new field ID in the database table CMN_FIELDS as given below:
Table 1-1 CMN _FIELDS Column Details
Column | Sample Value for Insight Mart | Sample Value for Argus Mart | Description |
---|---|---|---|
ENTERPRISE_ID |
3 |
3 |
Defines the current Enterprise ID. This is a mandatory column. |
FIELD_ID |
30000000 |
30000000 |
Defines the Oracle Argus Insight new field ID that must be unique and must be in the following range:
All other IDs are reserved for Oracle. This is a mandatory column. |
FIELD_LABEL |
Custom Product Country |
Custom Product Country |
Defined the field label having maximum length of 200 characters. This is a mandatory column. |
TABLE_NAME |
V_RPT_PRODUCT |
CASE_PRODUCT |
Defines the table name that contains the column for search criteria. The maximum length for the table name is 50 characters. This is a mandatory column. |
COLUMN_NAME |
COUNTRY_ID |
COUNTRY_ID |
Defines the column name for the search criteria. This column name must exist in table populated in TABLE_NAME. The maximum length of this column is 50 characters. This is a mandatory column. |
JOIN_FIELD |
COUNTRY_ID |
COUNTRY_ID |
Defines the column name if this field is of drop-down type on UI. This column contains the name of column that you want to use for join condition between the tables populated in TABLE_NAME and SELECT_TABLE. This is an optional column. |
SELECT_TABLE |
LM_COUNTRIES |
LM_COUNTRIES |
Defines the table name if this field is of drop-down type on UI. This column contains the name of table that you want to use to populate the drop-down values. This is an optional column. |
SELECT_COLUMN |
COUNTRY |
COUNTRY |
Defines the column name if this field is of drop-down type on UI. This column contains the name of column that you want to use to populate for the drop-down values. This is an optional column. |
ADV_COND_FIELD |
1 |
1 |
Contains the value for the new field ID as 1. This is a mandatory column. |
TREE_VIEW |
PRODUCTS:Product Information |
PRODUCTS:Product Information |
Defines the hierarchical structure of field in advance condition tree on Advance Condition Editor page. The first level and second level node of the tree must be separated by character ":". For example, First Level Tree Node: Second Level Tree Node This is a mandatory column. |
SQL_SELECT |
SELECT 1 ID, 'UNITED STATE' STATUS FROM DUAL UNION SELECT 2, 'UNITED KINGDOM' FROM DUAL UNION SELECT 3, 'INDIA' FROM DUAL |
SELECT 1 ID, 'UNITED STATE' STATUS FROM DUAL UNION SELECT 2, 'UNITED KINGDOM' FROM DUAL UNION SELECT 3, 'INDIA' FROM DUAL |
Defines the SQL query if this field is of drop-down type on UI. This column contains the selected query that you want to use to populate the drop-down values. This select query must contain the columns ID and STATUS. Note: If this column is configured then the values configured in columns SELECT_COLUMN, SELECT_TABLE and JOIN_FIELD will be ignored. This is an optional column. |
HIDDEN |
0 |
0 |
Contains the value for the new field ID as 0. This is a mandatory column. |
CONTROL_TYPE_ID |
2 |
2 |
Defines the ID of the control that you want to display on UI.Refer to the table CMN_CONTROL_TYPE for supported Control Type ID. 1 - Textbox 2 - Dropdown 3 - DatePicker 4 - DateTimePicker 5 - Numeric Control Type This is a mandatory column. |
ADDITIONAL_TABLE_LIST |
RPT_EVENT |
CASE_EVENT |
Defines the comma separated table list that is to be added in From clause of final SQL query except table name entered in the column Table_Name, and:
This field is required only if any additional join tables are required. This is an optional column. |
ADDITIONAL_WHERE |
V_RPT_PRODUCT.SEQ_NUM = RPT_EVENT.SEQ_NUM AND V_RPT_PRODUCT. COUNTRY_ID > 0 |
CASE_PRODUCT.SEQ_NUM = CASE_EVENT.SEQ_NUM AND CASE_PRODUCT. COUNTRY_ID > 0 |
Defines the additional Where clause that you want to add in the final SQL query of advance condition. This is an optional column. |
DATA_SOURCE_ID |
1 |
2 |
Defines the value of the target data source (Insight Mart/Oracle Argus Mart). This is a mandatory column. |
To configure remaining columns of the database table CMN_FIELDS, refer to the Oracle Argus Insight Database Administrator's Guide.
Parent topic: Advanced Conditions Extensibility