Update saved match-related reports following background changes in version 12.183 (journal match table)
This guide has been reviewed against our global client base and classed as relevant to all regions
Applicable from version 12.183
Background structure changes regarding the storage of journaled match information have been made which have implications for any previously saved reports that include reporting on match information in the journal
This guide covers:
What are the background changes in 12.183?
Version 12.183 introduces a new journal table specifically for the storage of match information called JNLMATCH (termed journal match table for this guide)
Prior to this version, the journal match information was stored in a central journal table along with all other journal entries
The new journal match table will only store match records, this includes the match-related journal types of: Match, Details Sent, Brochure Sent and Not Matched
This improved database structure will enhance efficiency and future functionality of your system
How does this impact my saved reports?
How to identify & fix affected reports
Identify affected report on Power Reports screen and/or Organiser panel Saved reports affected by the move to the journal match table will display with a large red exclamation mark - this will be seen when a report has been saved in the Power Reports screen and also when a report has been added to an Organiser panel
|
Fix saved Power Report
1. View affected report criteria From Power Reports:
|
2. Remove old journal match-related criteria & replace with new From the current criteria displaying the alert: a. Add new journal match-related criteria
b. Remove old match-related journal entry criteria - i.e. the criteria that is causing the alert
|
3. Delete saved report no longer needed If an affected report is no longer needed, it can be deleted instead From Power Reports:
|
Fix saved report on Organiser panel
1. Edit affected Organiser report criteria From Organiser panel:
In the Pick categories to display section:
|
2. Remove old journal match-related criteria & replace with new From the Edit Category screen:
a. Add new journal match-related criteria
b. Remove old match-related journal entry criteria - i.e. the criteria that is causing the alert
The old criteria is now removed and the report is pointing to the new journal match table:
|
Related articles