Subject: | Refactor back-office attachments to use standard framework attachment tables |
Summary: | Back-office attachments are stored in table LBS_Attachments. Standard framework tables is LT_SYS_Attachments. The following tasks are required: - Refactor back-office attachments to use standard framework attachment tables.
- Data conversion to migrate LBS_Attachments to the standard framework
- Remove LBS_Attachments table
|
Audit Notes: | Edited by sanjay on 05/03/19 09:01. |
21 Jun 2018 | 02:44PM Comment 1 by Alvis (Link Technologies) Case 9365 added to project 09.5 |
14 Aug 2018 | 04:58PM Comment 2 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 14-08-2018 04:58 PM Time Taken: 2.00 |
| Completed the following: 1. Refactor back-office attachments to use standard framework attachment tables.
|
|
15 Aug 2018 | 11:52AM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 15-08-2018 11:52 AM Time Taken: 4.00 |
| Development work for this case has been completed. The change will be available in version: 9.5 1. The following changes were made(Include Database object names, Program classes and any other relevant information):| - Refactor back-office attachments to use standard framework attachment tables.
- Data conversion to migrate LBS_Attachments to the standard framework
- Remove LBS_Attachments table
- Refactored leave attachment to use the same ID and module when uploading data into attachments table. This ensures both Backoffice and ESS can view the same data.
2. The issue was caused by: - N/A
3. Next Step - UAT
|
|
23 Aug 2018 | 07:43AM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 23-08-2018 07:43 AM |
| Proceed with UAT using LinkSOFT95BETA2 |
|
24 Aug 2018 | 01:28PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 24-08-2018 01:28 PM Time Taken: -2.00 |
| Hi Sanjay QA Results Tests carried out according to requirements specified on the case header Test Results Summary Table 1 - Summarised list of issues No | Test Description | Pass/Fail | 1 | Verify that LBS_Attachments table has been removed. | Pass. Filtered database table with attachment only result found was LT_SYS_Attachments | 2 | Users should be able to "Add", "View", "Remove" attachments in Backoffice without errors | Pass. Tested attachment on leave transaction screen | 3 | Validate that the attachments are actually stored in the DB | Pass. Did a select to validate. Refer to Figure 1. |
Figure 1: Attachment Select
Environment Details - OS version:Windows Server 2012
- Application version:9.5 Beta 2
- Setup: Demo
- Server : QA4
- Database:LINKSOFT-UAT95-LINKFJ
Steps to reproduce failed scenarios: - N/A
Next Step: Case assigned Sanjay for closure. |
|
28 Aug 2018 | 09:14AM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 28-08-2018 09:14 AM |
| Thanks Rashna |
|
09 Oct 2019 | 08:14AM Comment 7 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019 |