Company: Link Technologies
Case No: L12350. Project: 12.51: LinkSOFT version 12.51
Logged By: Sanjay (Link Technologies) on 05 Aug 2021 04:29PM
Priority: High
Product: Framework
Group: Enhancement
Time Taken: 6.00 (Weight: 6.00)
Version: 12.51.0813
Assigned To: Sanjay (Link Technologies)
Circulation: Rashna, Sanjay, Vineet
Resolve By: Friday, 13 August 2021 11:59 PM [966 days since logged date]
Status: Closed
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 202104: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):

  1. Added "Days to keep" to the Audit Setup
  2. Added Process Configuration to define the number of "Days to Keep" as a default value. Default set to 30 days
  3. Added Maintenance form changes to allow users to define 'Days to keep" and to perform bulk updates
  4. Added Delete operation to handle data purge

3. Affected Areas:

  1. Audit Maintenance
  2. Purge Process

4. The issue was caused by:

  1. Improvement

5. Other Relevant Notes
6. Next Step
(Review and System Test (Developer) -> UAT (Quality) -> Documentation):UAT


05 Aug 202104:29PM Comment 2 by Sanjay (Link Technologies) Case L12350 added to project 12.51
06 Aug 202101:30PM Comment 3 by Sanjay (Link Technologies) ETC was changed from 13/08/2021 to 13/08/2021
17 Aug 202109: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 DetailsPass/FailComments
 1
  1. Edit the "HR_EMPLOYEE" table and set the days to keep as 1. This should be completed without errors
 Pass 
 2
  1. Update the days to keep for "HR_EMPLOYEE" to 80 from the edit options on the bottom of the page
 Pass 
 3
  1. 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

  1. OS version:
  2. Application version: 12.51.0813GA
  3. Setup on:
    1. Server:LinkQA4
    2. Database: UAT-LINKSOFT
    3. LinkSOFT URL: HTTP://10.0.0.13/LINKSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


17 Aug 202105: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

If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12350 in the subject line of all emails regarding this issue.

Document size: 8.4 KB
For call complaints, please contact the Managing Director of the company using this form