Company: Link Technologies
Case No: L11985. Project: 12.10: LinkSOFT version 12.1
Logged By: Alvis (Link Technologies) on 27 May 2020 11:38AM
Priority: Low
Product: Framework
Group: Enhancement
Time Taken: 6.00 (Weight: 6.00)
Version: 12.10.1020
Assigned To: Rashna (Edge Business Solutions)
Circulation: Alvis, Rashna
Resolve By: Wednesday, 27 May 2020 12:00 AM [1431 days since logged date]
Status: Closed
Subject: Module configuration added to menu items
Summary:    

Some screens have a very large amount of data that is loaded. We need a configuration that limits the number of rows returned to the screens to prevent overloading/performance issues.

An example is: A customer has 30,000 inventory items. When the user navigates to "inventory maintenance", 30,000 rows are returned and this causes slow performance.

Audit Notes:
27 May 202011:46AM Comment 1 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 29-05-2020 11:38 AM Time Taken: 4.00

Development work for this case has been completed.

The change will be available in version:11.5.0527

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

  1. Added "Module Configuration" options to "Global Administration -> Menu Maintenance"
  2. Added "rows to return" flag to the following menus:
    1. Helpdesk ~> View All Calls
    2. Inventory ~> Product Master
  3. The default values for "Rows to return" is zero, which means all rows will be returned.
  4. For "Inventory -> Product Master", if "rows to return" is changed to 1,000, a maximum of 1,000 rows will be displayed on the screen. Users can use search filters to narrow the search results.
  5. For "Helpdesk -> View All Calls", if "rows to return" is changed to 1,000, a maximum of 1,000 rows will be displayed on the screen. Users can use search filters to narrow the search results.
  6. Search priority index has been added to Product Master so that results are prioritized.

2. Affected Areas:

  1. Inventory -> Product Master
  2. Helpdesk -> View All Calls
  3. Global Administration -> Menu Maintenance -> Module Configuration 

3. The issue was caused by:

  1. Performance Improvement

4. Notes: 
5. Next Step: UAT, Documentation

----------------------

Development Reference:

  1. Changed menu build procedure for POS, HEL.
  2. Changed Inventory Search procedure
  3. Changed helpdesk view all calls search procedure

01 Jun 202007:59AM Comment 2 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 03-06-2020 07:31 AM Time Taken: 1.00
 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 "RowsToReturn" is added for the "Product Master" and "Helpdesk" under "Global Administration -  Menu Maintenance - Menu Configuration"
Pass
2

For the menu "Product Master". Set the row count as below

  1. RowsToReturn - 0, this should load all 1678 records on the Product Master.
  2. RowsToReturn - 10, this should load only 10 items on the Product Master.
    1. Search for item K196, this item is not in the list above. Users should be able to search for K196 as its a product. 
  3. RowsToReturn - 1650, this should load all 1678 records on the Product Master. 
  4. RowsToReturn - 1650
    1. The current item records are 1648.
    2. Create two items as "Test1" and "Test2". This should be loaded on the screen.
    3. Create third items as "Test3". This should be saved but not be loaded on the screen.
    4. Users should be able to search for item "Test3"
Pass
3

For the menu "View All Calls". Set the row count as below

Current Records

  • Assigned to Me - 148
  • All Cases - 466
  • Open Calls - 116
  • Logged by Me  - 101
  • My Calls - 150
  1. RowsToReturn - 0, this should load all 466 cases in the Helpdesk.
  2. RowsToReturn - 10, this should load only 10 cases under "Assigned to Me", "All Case Cases", "My Calls", "Open Calls" and "Logged by Me". 
    1. Search for item 9033 in all cases, this case is not in the list above. Users should be able to search for case 9033
  3. RowsToReturn - 500, this should load all cases
  4. RowsToReturn - 10
    1. The current "Assigned to Me" is 1480
    2. Create a new case and assign it to admin. Case 9477. The case should not be added to the list of 10 cases. 
    3. Users should be able to search for case 9477
Pass

Environment Details

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

Next Step: 

  1. Documentation

    02 Jun 202010:42AM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 04-06-2020 10:22 AM Time Taken: 1.00

    Hi Sanjay, 

    Documentation has been updated at LinkSOFT\LinkWebApplicationsPortal\Global Administration\Menu_Maintenance.htm

    Thanks
    Rashna


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

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