Company: Link Technologies
Case No: L12188. Project: 12.30: LinkSOFT Version 12.30
Logged By: Alvis (Link Technologies) on 01 Mar 2021 09:34AM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 2.50 (Weight: 4.00)
Version: 12.32
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay
Resolve By: Friday, 05 March 2021 11:59 PM [1144 days since logged date]
Status: Closed
Subject: Duplicate entries showing in "Search Delivery"

"Search Delivery" is showing duplicate entries for a batch. See screenshot below:

Audit Notes:Edited by alvis on 03/03/21 13:09. Edited by alvis on 03/03/21 08:27. Edited by alvis on 02/03/21 16:17. Edited by alvis on 01/03/21 09:34. 
01 Mar 202109:34AM Comment 1 by Alvis (Link Technologies) ETC was changed from 05/03/2021 to 05/03/2021
01 Mar 202101:56PM Comment 2 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 01-03-2021 07:47 PM Time Taken: 1.00
PART A - Impact Analysis Instructions:
1. Update the case header and ensure the Priority, Category, Group, Weight, and other details are correct
2. Update the case header with a clear and concise description of the problem.
3. Itemize and number each section so it can be clearly referenced.
4. Update the case Subject to clearly describe the issue
5. If there is a significant change to the effort, assign the case to Sanjay for approval.
6. Cleanup the case header and ensure blank lines and formatting is neat. The case should contain relevant statements only.

PART B - Analysis
1. Verify the request. If System Issue, verify the issue exists. If New/Improvement, verify justification.
2. The following changes will be required
a. Change the procedure that extracts delivery batches to use GROUP BY batch number instead of DISTINCT.

2. Affected Areas:
a. POS -> Delivery Search

3. The issue was caused by: Use of DISTINCT in a combination with the modified date has caused the issue.

Is there a significant change in the effort to complete this case: No
Next Step: proceed with the development


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

1. Other areas in the system that could have a similar issue (and provide next steps): The two issues identified in this case has been noted and will be applied to any future changes to procedures, they are:
a. Input parameter cleaning to be implemented using functions.

b. When distinct is used in a select, having a modified date may cause duplicate entries.

01 Mar 202102:00PM Comment 3 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 01-03-2021 07:58 PM Time Taken: 1.00
PART A - Development Completed Instructions:
Before Development is started, ensure the following is ready:
1. The case has a clear definition of the issue or change required
2. A test plan is in place
3. Change has been approved by Sanjay

a. System Test is performed by development in the "Finalised" Development environment ({version}
b. UAT is performed using the installation provided

PART B - Development work for this case has been completed.

1. The change will be available in version:12.4

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

  1. LBS_POS_GetDeliveryBatch - Changed data extraction for delivery search as identified in impact analysis

3. Affected Areas:

  1. POS -> Process Deliveries -> Load -> Search

4. The issue was caused by:

  1. Use of DISTINCT in a combination with the modified date has caused the issue.

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


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

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

2. Other relevant notes:

02 Mar 202104:17PM Comment 4 by Alvis (Link Technologies) Case L12188 added to project 12.3
12 Mar 202103:52PM Comment 5 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 12-03-2021 09:51 PM

15 Mar 202101:27PM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 15-03-2021 07:22 PM 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

Create 2 delivery batches BA000001 and BA000002.

Load and search for the batches. Validate that the batch numbers appear only once on the list


Environment Details

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

Next Step

  1. For Closure

    15 Mar 202104:04PM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 15-03-2021 10:04 PM
    Thanks Rashna

    If you have any queries regarding this support incident, please email and include the Case No: L12188 in the subject line of all emails regarding this issue.

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