5.18 Configuring the Parameters for Highlighting the Matched Data

You can configure parameters to highlight the matched data inside tag value when the event parameters match with the alert in the Alert Details page. For more information on Alert Details, see Oracle Financial Services Transaction Filtering User Guide.

To configure the parameters to highlight the matched data inside tag value, follow the below steps:

  1. Access the Atomic Schema and access the SETUP_RT_PARAMS table.
  2. Insert the attribute value for the required parameters in the table. For example, to consider the matched data for BIC, follow the below steps:
    1. Access the Atomic Schema and access the SETUP_RT_PARAMS table.
    2. Insert the regular expression for EXACT_HIGHLIGHT_REGEX in the table.

For example, the regular expression value[A-Za-z0-9]{4}[A-Za-z]{2}[A-Za-z0- 9]{2}[A-Za-z0-9]{0,3} satisfies BIC codes to highlight the matched data.

Figure 5-13 SETUP_RT_PARAMS


SETUP_RT_PARAMS


MERGE INTO SETUP_RT_PARAMS T USING (
SELECT '500' N_PARAM_IDENTIFIER, 'EXACT_HIGHLIGHT_REGEX' V_PARAM_NAME, '' V_CREATED_BY, to_date('15-11-2022' , 'dd-mm-yyyy') D_CREATED_DATE, 'TFADMN' V_MODIFIED_BY, 'HIGHLIGHT_BICCODE_REGEX' V_ATTRIBUTE_NAME1, to_date('15-11- 2022' , 'dd-mm-yyyy') D_MODIFIED_DATE, '[A-Z]{6,6}[A-Z2-9][A-NP-Z0-9]([A-Z0-
9]{3,3}){0,1}' V_ATTRIBUTE_VALUE1, '' V_ATTRIBUTE_NAME2, '' V_ATTRIBUTE_VALUE2, '' V_ATTRIBUTE_NAME3, '' V_ATTRIBUTE_VALUE3, ''
V_ATTRIBUTE_NAME4, '' V_ATTRIBUTE_VALUE4, 'List of BIC codes to be used to highlight 2 digit county code within the matches.' V_ATTRIBUTE1_DESCRIPTION, '' V_ATTRIBUTE2_DESCRIPTION, '' V_ATTRIBUTE3_DESCRIPTION, '' V_ATTRIBUTE4_DESCRIPTION, '' V_PARAM_DESC, '' V_ATTRIBUTE_NAME5, '' V_ATTRIBUTE5_DESCRIPTION, '' V_ATTRIBUTE_VALUE5 FROM DUAL) S
ON ( T.N_PARAM_IDENTIFIER = S.N_PARAM_IDENTIFIER )
WHEN MATCHED THEN UPDATE SET T.V_PARAM_NAME = S.V_PARAM_NAME, T.V_CREATED_BY
= S.V_CREATED_BY, T.D_CREATED_DATE = S.D_CREATED_DATE, T.V_MODIFIED_BY = S.V_MODIFIED_BY, T.V_ATTRIBUTE_NAME1 = S.V_ATTRIBUTE_NAME1, T.D_MODIFIED_DATE
= S.D_MODIFIED_DATE, T.V_ATTRIBUTE_VALUE1 = S.V_ATTRIBUTE_VALUE1, T.V_ATTRIBUTE_NAME2 = S.V_ATTRIBUTE_NAME2, T.V_ATTRIBUTE_VALUE2 = S.V_ATTRIBUTE_VALUE2, T.V_ATTRIBUTE_NAME3 = S.V_ATTRIBUTE_NAME3, T.V_ATTRIBUTE_VALUE3 = S.V_ATTRIBUTE_VALUE3, T.V_ATTRIBUTE_NAME4 = S.V_ATTRIBUTE_NAME4, T.V_ATTRIBUTE_VALUE4 = S.V_ATTRIBUTE_VALUE4, T.V_ATTRIBUTE1_DESCRIPTION = S.V_ATTRIBUTE1_DESCRIPTION,
T.V_ATTRIBUTE2_DESCRIPTION = S.V_ATTRIBUTE2_DESCRIPTION, T.V_ATTRIBUTE3_DESCRIPTION = S.V_ATTRIBUTE3_DESCRIPTION, T.V_ATTRIBUTE4_DESCRIPTION = S.V_ATTRIBUTE4_DESCRIPTION, T.V_PARAM_DESC = S.V_PARAM_DESC, T.V_ATTRIBUTE_NAME5 = S.V_ATTRIBUTE_NAME5, T.V_ATTRIBUTE5_DESCRIPTION = S.V_ATTRIBUTE5_DESCRIPTION, T.V_ATTRIBUTE_VALUE5
= S.V_ATTRIBUTE_VALUE5
WHEN NOT MATCHED THEN INSERT
 (N_PARAM_IDENTIFIER,V_PARAM_NAME,V_CREATED_BY,D_CREATED_DATE,V_MODIFIED_BY,V
 _ATTRIBUTE_NAME1,D_MODIFIED_DATE,V_ATTRIBUTE_VALUE1,V_ATTRIBUTE_NAME2,V_ATTR IBUTE_VALUE2,V_ATTRIBUTE_NAME3,V_ATTRIBUTE_VALUE3,V_ATTRIBUTE_NAME4,V_ATTRIB UTE_VALUE4,V_ATTRIBUTE1_DESCRIPTION,V_ATTRIBUTE2_DESCRIPTION,V_ATTRIBUTE3_DE SCRIPTION,V_ATTRIBUTE4_DESCRIPTION,V_PARAM_DESC,V_ATTRIBUTE_NAME5,V_ATTRIBUT E5_DESCRIPTION,V_ATTRIBUTE_VALUE5)
VALUES
 (S.N_PARAM_IDENTIFIER,S.V_PARAM_NAME,S.V_CREATED_BY,S.D_CREATED_DATE,S.V_MOD IFIED_BY,S.V_ATTRIBUTE_NAME1,S.D_MODIFIED_DATE,S.V_ATTRIBUTE_VALUE1,S.V_ATTR IBUTE_NAME2,S.V_ATTRIBUTE_VALUE2,S.V_ATTRIBUTE_NAME3,S.V_ATTRIBUTE_VALUE3,S. V_ATTRIBUTE_NAME4,S.V_ATTRIBUTE_VALUE4,S.V_ATTRIBUTE1_DESCRIPTION,S.V_ATTRIB UTE2_DESCRIPTION,S.V_ATTRIBUTE3_DESCRIPTION,S.V_ATTRIBUTE4_DESCRIPTION,S.V_P ARAM_DESC,S.V_ATTRIBUTE_NAME5,S.V_ATTRIBUTE5_DESCRIPTION,S.V_ATTRIBUTE_VALUE 5)

/