| Subject: | Purge Audit Records should be configured at a Table level so that we can keep master files for a longer period compared to Transactions. |
| Summary: | Purge Audit Records should be configured at a Table level so that we can keep master files for a longer period compared to Transactions. |
| Audit Notes: | Edited by sanjay on 06/08/21 13:30. Edited by sanjay on 05/08/21 16:29. |
| 05 Aug 2021 | 04:24PM Comment 1 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 05-08-2021 08:21 PM Time Taken: 4.00 |
| PART A - Development work for this case has been completed. 1. The change will be available in version: 12.51.0805 2. The following changes were made(Include Database object names, Program classes, and any other relevant information): - Added "Days to keep" to the Audit Setup
- Added Process Configuration to define the number of "Days to Keep" as a default value. Default set to 30 days
- Added Maintenance form changes to allow users to define 'Days to keep" and to perform bulk updates
- Added Delete operation to handle data purge
3. Affected Areas: - Audit Maintenance
- Purge Process
4. The issue was caused by: - Improvement
5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation):UAT
|
|
| 05 Aug 2021 | 04:29PM Comment 2 by Sanjay (Link Technologies) Case L12350 added to project 12.51 |
| 06 Aug 2021 | 01:30PM Comment 3 by Sanjay (Link Technologies) ETC was changed from 13/08/2021 to 13/08/2021 |
| 17 Aug 2021 | 09:41AM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 17-08-2021 12:27 PM Time Taken: 1.00 |
|
The following tests were performed:
Table 1 - Test Results
| # | Test Case Details | Pass/Fail | Comments | | 1 | - Edit the "HR_EMPLOYEE" table and set the days to keep as 1. This should be completed without errors
| Pass | | | 2 | - Update the days to keep for "HR_EMPLOYEE" to 80 from the edit options on the bottom of the page
| Pass | | | 3 | - Validate that the audit data for HR_EMPLOYEE is removed after 1 day
| Pass | If a record is added on 16/08/2021 the record will be removed when 17/08/2021 ends. |
Environment Details - OS version:
- Application version: 12.51.0813GA
- Setup on:
- Server:LinkQA4
- Database: UAT-LINKSOFT
- LinkSOFT URL: HTTP://10.0.0.13/LINKSOFT
- Login Details: Standard username and password for user "admin"
Next Step: Closure
|
|
| 17 Aug 2021 | 05:37PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 17-08-2021 09:37 PM Time Taken: 1.00 |
| Thanks Rashna |
|