| Subject: | Multiple Minor changes to LinkSOFT to improve Usability, Functionality and Stability |
| Summary: | List of changes implemented that are small in nature. Each change is described in the comments section. Table 1 - Checklist of changes: | ID | Description | Status | | 1 | Add New Standard Indexes for Integration, Configuration and Inventory Modules | Completed
| 2
| Removed Process Scheduler START and END "Time Update" when an upgrade is performed
| Completed
| 3
| Added "Rows To Return" in the form "Email Log" as some emails are very large and can cause performance issues.
| Completed
| 4
| Changed Validation Error Text from "*required" to "Required"
| Completed
|
|
| Audit Notes: | Edited by sanjay on 17/02/23 11:31. Edited by sanjay on 03/02/23 14:30. Edited by sanjay on 03/02/23 14:02. Edited by sanjay on 02/02/23 16:49. Edited by sanjay on 02/02/23 16:12. Edited by sanjay on 31/01/23 15:55. Edited by sanjay on 31/01/23 11:31. |
| 31 Jan 2023 | 11:31AM Comment 1 by Sanjay (Link Technologies) Case L12834 added to project 14.50 |
| 31 Jan 2023 | 11:33AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 10-02-2023 11:31 AM Time Taken: 6.00 |
| Below is a list of Standard Indexes added: - INSERT INTO #StandardIndexes(TableName,IndexName,IndexType) SELECT 'LBS_INVENTORY','LBS_Inventory_Category_IX','NONCLUSTERED'
- INSERT INTO #StandardIndexes(TableName,IndexName,IndexType) SELECT 'LT_SYS_ConfigurationRule','IX_LT_SYS_ConfigurationRule_RuleCode','NONCLUSTERED'
- INSERT INTO #StandardIndexes(TableName,IndexName,IndexType) SELECT 'LT_SYS_Integration','IX_LT_SYS_Integration_Code','NONCLUSTERED'
- INSERT INTO #StandardIndexes(TableName,IndexName,IndexType) SELECT 'LT_SYS_IntegrationRules','IX_LT_SYS_IntegrationRules_IntegrationID_RuleCode','NONCLUSTERED'
- INSERT INTO #StandardIndexes(TableName,IndexName,IndexType) SELECT 'LT_SYS_ModuleConfiguration','IX_LT_SYS_ModuleConfiguration_Flag','NONCLUSTERED'
|
|
| 02 Feb 2023 | 04:12PM Comment 3 by Sanjay (Link Technologies) ETC was changed from 27/01/2023 to 31/03/2023 |
| 07 Feb 2023 | 12:45PM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 17-02-2023 12:43 PM Time Taken: 4.00 |
| The Time and Attendance API is receiving an error when the same BATCH is sent from the source multiple times. We will allow this since it is possible to resend a Batch from a TNA device. We now DELETE the old Batch and Reimport the NEW Batch. The Logs will show the Batch that was deleted. |
|
| 24 Feb 2023 | 09:13AM Comment 5 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 03-03-2023 09:10 AM Time Taken: 4.00 Notes: ETC extended from: 31/03/2023 to 03/03/2023 |
| The "Leave Adjustments Form" filter for column "Status" does not allow the user to type text in the filter section. The issue was caused by the "Status Column" incorrectly assigned a "DROP DOWN" field type which did not have data binding. This field should be a TEXT field as the "Status Column" is automatically assigned. The issue has been corrected in 14.50 by changing the Status Field from DROPDOWN to TEXT |
|
| 28 Feb 2023 | 04:16PM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 10-03-2023 04:03 PM Time Taken: 12.00 |
|
The following tests were performed:
Test Setup Instructions: - Review indexes and use demo data to check filters
Table 1 - Test Results
| # | Test Area | Pass/Fail | | 1 | Leave Adjustments Form - Status Filter does not allow user entry | Pass | | 2 | Time and Attendance API is receiving an error when the same BATCH is sent from the source multiple times. REF: Integration_WebAPI_TimeAndAttendanceSend_Finalise | Pass | | 3 | Verify Index: 'LBS_INVENTORY','LBS_Inventory_Category_IX','NONCLUSTERED' | Pass | | 4 | Verify Index: 'LT_SYS_ConfigurationRule','IX_LT_SYS_ConfigurationRule_RuleCode','NONCLUSTERED' | | | 5 | Verify Index: 'LT_SYS_Integration','IX_LT_SYS_Integration_Code','NONCLUSTERED' | Pass | | 6 | Verify Index: 'LT_SYS_IntegrationRules','IX_LT_SYS_IntegrationRules_IntegrationID_RuleCode','NONCLUSTERED' | Pass | | 7 | Verify Index: 'LT_SYS_ModuleConfiguration','IX_LT_SYS_ModuleConfiguration_Flag','NONCLUSTERED' | Pass |
Environment Details - OS version: Win11
- Application version: 14.50
- Setup on:
- Server: LinkQA4
- Database: LinkSOFT
- LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
- Login Details: Standard username and password for user "admin"
Next Step: Closure
|
|