Company: Link Technologies
Case No: L12911. Project: 14.90: LinkSOFT Version 14.90 - July 2023
Logged By: Sanjay (Link Technologies) on 31 May 2023 03:14PM
Priority: High
Product: Framework
Group: Software Defect
Time Taken: 14.00 (Weight: 12.00)
Assigned To: Development
Circulation: Development, Sanjay
Resolve By: Wednesday, 14 June 2023 05:13 PM [323 days since logged date]
Status: Closed
Subject: Report Schedule - When date offset of "All" is selected, the report takes a long time to run
Summary:    Report Schedule - When date offset of "All" is selected, the report takes a long time to run
Audit Notes:Edited by sanjay on 21/06/23 15:27. 
31 May 202303:18PM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 31-05-2023 09:14 PM Time Taken: 7.00
PART A - Development work for this case has been completed.

1. The change will be available in version: 14.90

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

  1. Changed the Default DATE FROM to the "First Day of the current year" when the user chooses an unlimited date range.
  2. In the Report Schedule, choosing "All" as the date range causes the dates to pick up as "1900/01/01" to "2999/02/31". This has been changed to "{Current Year}/01/01" to "{Current Year}/02/31". If you need to cast a wider date range, use the "Year" +/- an offset.

3. Affected Areas:

  1. Report Schedule

4. The issue was caused by:

  1. Users must choose a specific date for scheduled reports. Choosing an OPEN date range can cause a very large amount of data to be loaded which can cause performance issues.

5. Other Relevant Notes


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


14 Jun 202311:37AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 14-06-2023 05:13 PM Time Taken: 7.00 Notes: ETC extended from: 31/05/2023 to 14/06/2023
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Create a scheduled report using DATE FROM = "ALL" and DATE TO = "ALL"
The report should run for the date range 01/01/2023 to 31/12/2023
Pass

2Create a scheduled report using DATE FROM = MONTH (Offset -1) and DATE TO = "ALL"
The report should run for the date range 01/05/2023 to 31/12/2023
Pass

3Create a scheduled report using DATE FROM = MONTH (Offset -1) and DATE TO = "MONTH" OFFSET -1
The report should run for the date range 01/05/2023 to 31/05/2023
Pass

4



5



Environment Details

  1. OS version: Win11
  2. Application version: 14.90
  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: L12911 in the subject line of all emails regarding this issue.

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