Company: Link Technologies
Case No: L10121. Project: 11.40: LinkSOFT Version 11.4
Logged By: Rashna (Edge Business Solutions) on 07 Feb 2019 02:54PM
Priority: Medium
Product: Helpdesk
Group: Software Defect
Time Taken: 22.00 (Weight: 22.00)
Version: 11.3.0902
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay
Resolve By: Friday, 08 February 2019 12:00 AM [1905 days since logged date]
Status: Closed
Subject: Add "Word Wrap" to the "Contact Number" column on the "Call Analysis Report - Excel Output" report.
Summary:    

"Contact Number" field merges with "Responsibility" column on the "Call Analysis Report - Excel Output".

Verified in version 10.2

Figure 1: Current Preview



Audit Notes:Edited by alvis on 02/04/19 16:07. 
07 Feb 201902:55PM Comment 1 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 07-02-2019 02:55 PM Time Taken: 2.50

Hi Sanjay,

For review and project allocation.

Thanks
Rashna


08 Feb 201901:28PM Comment 2 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 08-02-2019 01:28 PM Time Taken: 1.50 Notes: Edited by sanjay on 08/02/19 13:31. 
approved for 10.140

02 Apr 201904:07PM Comment 3 by Alvis (Link Technologies) Case 10121 added to project 11.0
11 Apr 201911:15AM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 11-04-2019 11:15 AM Time Taken: 5.50

Development work for this case has been completed.

The change will be available in version: 11.0.0411

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

  1. Removed report "Call Analysis Report (Excel Output)". This report was initially designed to export into excel and it does not use the standard A4 paper size.
  2. Added "Show Data" functionality to "Call Analysis Report". Users using "Call Analysis Report (Excel Output)" can use the "Show Data" to get the same data in excel.
  3. Implemented standard report framework.
  4. Implemented full-text search for the search filter.
  5. When the SQL Server supports Full-Text Search, the report search is based on the following:
    1. Call Number
    2. Reference
    3. Subject
    4. Summary
    5. Comments
    6. Comment's Reference
  6. For SQL Servers that do not support Full-Text search, the search is based on the standard framework for report fields:
    1. Call Number
    2. Logged Date
    3. Logged By
    4. Logged By Organisation
    5. Category
    6. Priority
    7. Group
    8. Closed Date
    9. Closed By
    10. Assigned To
    11. Status
    12. Subject
    13. Alt Contact Num

2. The issue was caused by:

  1. Improvement

3. Next Step:

  1. UAT

4. Notes:


15 Apr 201903:04PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 23-04-2019 12:00 AM Time Taken: 3.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
1Validate that the report name "Call Analysis Report" is consistent in the reportPass.
2Verify that the report label is consistent with the report filtersPass
3Verify that "View Data in Grid" correctly loads the report contents

Fails,

"View Data in Grid" loads the data from the report and loads the report filters in separate columns.

4

Test the report filters

Fails

  • Generate the report with dates 06/06/2018 to 06/06/2018 with date type as "logged date".
    • Report result - No Records
    • Helpdesk has cases 9325 and 9326

  • Generate the report with dates 01/01/2018 to 31/01/2018 with date type as "logged date" and category = "Backoffice".
    • Report result - No Records
    • Helpdesk has case 9059

  • Generate the report with dates 01/07/2018 to 31/07/2018 with date type as "logged date" and group= "System Issue".
    • Report result - No Records
    • Helpdesk has case 9429

  • Generate the report with dates 16/07/2018 to 16/07/2018 with date type as "logged date" and Status = "System Issue".
  • Report result - Prints only 9431
  • Helpdesk has cases 9435, 9432 and 9431


Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 11.0.0415
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database:LINKSOFT-DEMO-11-RASHNA

Next Step: for correction


    23 Apr 201911:14AM Comment 6 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 23-04-2019 11:14 AM Time Taken: 2.50

    Development work for this case has been completed.

    The change will be available in version: 11.0.0423

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

    1. Removed columns not required from the "show data".
    2. Replaced parameter Category, Priority and Group to display the description instead of ID.
    3. I have tested the report filters and it is working fine. I am unable to replicate your scenarios.

    2. The issue was caused by:

    1. Improvement

    3. Next Step:

    1. UAT

    4. Notes:


    30 Apr 201912:32PM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 10-05-2019 12:00 AM Time Taken: 2.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
    1Verify that "View Data in Grid" correctly loads the report contents and report filters have been removed from the output. Pass
    2

    Test report filers


    • Generate the report with dates 06/06/2018 to 06/06/2018 with date type as "logged date".
      • Helpdesk has cases 9325 and 9326

    • Generate the report with dates 01/01/2018 to 31/01/2018 with date type as "logged date" and category = "Backoffice".
      • Helpdesk has case 9059

    • Generate the report with dates 01/07/2018 to 31/07/2018 with date type as "logged date" and group= "System Issue".
      • Helpdesk has case 9429

    • Generate the report with dates 16/07/2018 to 16/07/2018 with date type as "logged date" and Status = "Closed".
    • Helpdesk has cases 9435, 9432 and 9431
    		Pass
    3Verify parameters Category, Priority and Group to display the description.Pass

    Environment Details

    1. OS version: Windows Server 2012
    2. Application version: 11.0.0429
    3. Setup: Demo
    4. Server : 10.0.0.14
    5. Database:LINKSOFT-DEMO-11-RASHNA

    Next Step: Documentation


      02 May 201907:03AM Comment 8 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 03-05-2019 12:00 AM Time Taken: 2.50

      Hi Sanjay, 

      Documentation for the case has been updated under Link Web-> Business Intelligence-> Helpdesk Reports ->Call Analysis Report

      Thanks
      Rashna


      07 May 201903:20PM Comment 9 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 07-05-2019 03:20 PM Time Taken: 1.50
      Thanks Rashna

      09 Oct 201908:14AM Comment 10 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
      If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L10121 in the subject line of all emails regarding this issue.

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