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).