Company: Link Technologies
Case No: L12148. Project: 12.30: LinkSOFT Version 12.30
Logged By: Rashna (Edge Business Solutions) on 22 Jan 2021 01:35PM
Priority: Low
Product: Framework
Group: Enhancement
Time Taken: 7.50 (Weight: 7.50)
Version: 12.32
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Friday, 19 March 2021 11:59 PM [1181 days since logged date]
Status: Closed
Subject: Add the ability to enable "Audit" for multiple table as once
Summary:    

During UAT I wanted to enable the audit for all payroll tables, there are around 41 tables.

To accomplish the above, I have to edit each row and enable the "Insert, Update and Delete" options

Can we allow users to select multiple tables and enable the "Insert, Update and Delete"  commands in bulk.

This would be similar to "Role Menu Access".

Audit Notes:Edited by sanjay on 12/03/21 15:57. Edited by sanjay on 03/03/21 08:15. Edited by alvis on 25/02/21 10:48. Edited by rashna on 25/02/21 10:30. Edited by sanjay on 02/02/21 17:38. 
22 Jan 202101:36PM Comment 1 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 26-01-2021 05:00 PM Time Taken: 1.00 Notes: ETC extended from: 23/01/2021 to 26/01/2021

Hi Sanjay, 

Case assigned for review and approval.

Thanks
Rashna


02 Feb 202105:37PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 30-06-2021 05:37 PM
Approved for development in 12.4

02 Feb 202105:38PM Comment 3 by Sanjay (Link Technologies) Case L12148 added to project 12.4
25 Feb 202110:30AM Comment 4 by Rashna (Edge Business Solutions) ETC was changed from 26/01/2021 to 19/03/2021
03 Mar 202108:15AM Comment 5 by Sanjay (Link Technologies) Case L12148 added to project 12.3
09 Mar 202102:03PM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 11-03-2021 01:29 PM Time Taken: 6.00
PART A - Development work for this case has been completed.

1. The change will be available in version: 12.32

2. The following changes were made(Include Database object names, Program classes, and any other relevant information):

  1. Added ability to select multiple tables and apply audit 

3. Affected Areas:

  1. Audit Setup

4. The issue was caused by:

  1. Improvement

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

----------------------

PART B - Development Reference (Place descriptor for objects changed):

1. Changes implemented was according to the approved design (Y/N):

2. Other relevant notes:


12 Mar 202103:57PM Comment 7 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 17-03-2021 03:57 PM
For UAT

15 Mar 202109:18AM Comment 8 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 17-03-2021 09:05 AM Time Taken: 0.50
QA Results
Tests carried out according to requirements specified on the case header

Test Results Summary

Table 1 - Summarised list of issues
NoTest DescriptionPass/Fail
1Validate that the "Insert", "Update", "Delete" and "Custom" options are available to apply changes in bulk.Pass
2
  1. Filter tables by "Employee", select all. 
  2. Check all 4 options in 1 above and "Apply".
  3. This should enable the audit settings for all selected tables only.
Pass
3
  1. Uncheck the "Delete" and "Custom" options
  2. "Apply
  3. This should remove the audit settings.
Pass

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 12.32.0312BETA
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-123

Next Step

  1. For Closure

    15 Mar 202104:09PM Comment 9 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 17-03-2021 04:08 PM
    Thanks Rashna

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

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