Configure CMN_COMPLEXFIELD_CONFIGURATION Table
The table CMN_COMPLEXFIELD_CONFIGURATION is used to configure fields that have very complex business logic. You can also use this table if you want to specify different condition for different operators in WHERE clause. You should define WHERE condition against each operator.
Table 1-29 CMN_COMPLEXFIELD_CONFIGURATION Column Details
Column | Sample Value | Description |
---|---|---|
ENTERPRISE_ID |
3 |
Current Enterprise ID |
FIELD_ID |
30000000 |
New Field ID |
OPERATOR |
contains |
Enter the desired operator to support the new Field ID. See Table 1-30 for configuration. This is a mandatory column. |
SORT_ORDER |
6 |
Enter the sorting order of operator. This is a mandatory column. |
REQ_TABLE_LIST |
-- |
Add the common separated table list in FROM Clause of final SQL query except V_RPT_CASE, and table name entered in Table_Name Column. This is an optional column. |
WHERE_QUERY |
(UPPER(V_RPT_PRODUCT.PRODUCT_NAME) NOT LIKE UPPER('%PARAM_VALUE%') AND V_RPT_PRODUCT.pat_exposure > 0 ) |
Define the WHERE clause for the new field ID against the operator entered in Operator Column. This is a mandatory column. Note: Use the Place holder <<PARAM_VALUE>> in WHERE clause of SQL query, where selected value is to be placed. |
The following are the supported operators for the new field IDs:
Table 1-30 Supported Operator List
Operator | Description |
---|---|
equal to |
Retrieves cases where the selected attribute's value is equal to what the Value field specifies. |
not equal to |
Retrieves cases where the selected attribute's value is not equal to what the Value field specifies. |
greater than |
Retrieves cases where the selected attribute's value is greater than what the Value field specifies. |
greater than or equal to |
Retrieves cases where the selected attribute's value is greater than or equal to what the Value field specifies. |
less than |
Retrieves cases where the selected attribute's value is less than what the Value field specifies. |
less than or equal to |
Retrieves cases where the selected attribute's value is less than or equal to the Value that the field specifies. |
missing |
Retrieves cases where the selected attribute's value has not been specified. |
exists |
Retrieves cases where the selected attribute has any value. |
begins with |
Retrieves cases where the selected attribute's value begins with what the Value field specifies. |
contains |
Retrieves cases where the selected attribute's value contains what the Value field specifies. |
does not contain |
Retrieves cases where the selected attribute's value does not contain what the Value field specifies. |
in |
Retrieves cases where the selected attribute's value exists in what the Value field specifies. |
not in |
Retrieves cases where the selected attribute's value does not exist in what the Value field specifies. |
Note:
You can also refer to existing field PRODUCTS > Study Drug, (CMN_FIELDS.Field_ID - 203650965).Parent topic: Advanced Conditions Extensibility