Company: Link Technologies
Case No: L12834. Project: 14.50: LinkSOFT Version 14.50 - March 2023
Logged By: Sanjay (Link Technologies) on 31 May 2022 02:55PM
Priority: Low
Product: Framework
Group: Enhancement
Time Taken: 26.00
Assigned To: Development
Circulation: Development, Sanjay
Resolve By: Friday, 03 March 2023 09:10 AM [688 days since logged date]
Status: Closed
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:

IDDescriptionStatus
1Add New Standard Indexes for Integration, Configuration and Inventory ModulesCompleted
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 202311:31AM Comment 1 by Sanjay (Link Technologies) Case L12834 added to project 14.50
31 Jan 202311: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:

  1. INSERT INTO #StandardIndexes(TableName,IndexName,IndexType) SELECT 'LBS_INVENTORY','LBS_Inventory_Category_IX','NONCLUSTERED'
  2. INSERT INTO #StandardIndexes(TableName,IndexName,IndexType) SELECT 'LT_SYS_ConfigurationRule','IX_LT_SYS_ConfigurationRule_RuleCode','NONCLUSTERED'
  3. INSERT INTO #StandardIndexes(TableName,IndexName,IndexType) SELECT 'LT_SYS_Integration','IX_LT_SYS_Integration_Code','NONCLUSTERED'
  4. INSERT INTO #StandardIndexes(TableName,IndexName,IndexType) SELECT 'LT_SYS_IntegrationRules','IX_LT_SYS_IntegrationRules_IntegrationID_RuleCode','NONCLUSTERED'
  5. INSERT INTO #StandardIndexes(TableName,IndexName,IndexType) SELECT 'LT_SYS_ModuleConfiguration','IX_LT_SYS_ModuleConfiguration_Flag','NONCLUSTERED'

02 Feb 202304:12PM Comment 3 by Sanjay (Link Technologies) ETC was changed from 27/01/2023 to 31/03/2023
07 Feb 202312: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 202309: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 202304: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:
  1. Review indexes and use demo data to check filters
Table 1 - Test Results
#Test AreaPass/Fail
1Leave Adjustments Form - Status Filter does not allow user entryPass
2Time and Attendance API is receiving an error when the same BATCH is sent from the source multiple times. REF: Integration_WebAPI_TimeAndAttendanceSend_FinalisePass
3Verify Index: 'LBS_INVENTORY','LBS_Inventory_Category_IX','NONCLUSTERED'Pass
4Verify Index: 'LT_SYS_ConfigurationRule','IX_LT_SYS_ConfigurationRule_RuleCode','NONCLUSTERED' 
5Verify Index: 'LT_SYS_Integration','IX_LT_SYS_Integration_Code','NONCLUSTERED'Pass
6Verify Index: 'LT_SYS_IntegrationRules','IX_LT_SYS_IntegrationRules_IntegrationID_RuleCode','NONCLUSTERED'Pass
7Verify Index: 'LT_SYS_ModuleConfiguration','IX_LT_SYS_ModuleConfiguration_Flag','NONCLUSTERED'Pass

Environment Details

  1. OS version: Win11
  2. Application version: 14.50
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


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

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