7.11 Configuring Additional Columns on the Related Alerts Page
This configurability allows you to add additional column(s) on the Related
Alerts page and view additional information.
It also provides configurability to execute the customized query to
fetch the data in the columns against each Alert ID.
To add a column on the Related Alerts page and filters, follow these
steps:
- In Atomic Schema, for the table FCC_SANC_LIST_PAGE_QUERY_CONF, find the query present in the column V_QUERY for V_QUERY_IDENTIFIER = 'CS_RELATED_ALERTS'.
- In the above query, check if the column to be added in related alerts page, is present or not.
- If present, note down the column name (or alias name, if present). If not present, add necessary changes in the sql, and note down it's column name (or alias name, if given).
- Open the AuditScreen.js from the below path in deployed area.../<DEPLOYED_WAR>/ CustomerScreening/js/viewModels.
- Search by the 'self.auditcolumnArray = ko.observableArray([{' in the above page where params.data.moduleName == "Related Alerts" is present as condition check.
- Add a new json object for header details for the new column to be added just like the exisitng ones.
- In the newly added json object for header details, for headerText field, provide appropriate value from CSMessageConstants.jsp which will be shown as column name in related alerts page.
- If there is no appropriate entry present in CSMessageConstants.jsp, create a new one by giving entry in messages_en_us table and CSMessageConstants.jsp.
- Restart server (only if the step 8 is executed).
- Clear browser cache (if js file is changed).
- Re-login and check the related alerts page.