0049629: Performance Issue in Inventory Count when loading all Products in parameters

Description

In the FE, in the parameters window of the Inventory Count, in the Product parameter, without filters it loads all the products creating a performance problem.

Video: https://watch.screencastify.com/v/SAlDovn7A9VCNLy371Y3 [^]

Steps To Reproduce

1. Log in as Openbravo in AWO-QA Admin client
  (To do so, log in as Openbravo in the BackOffice first and change the Role to AWO-QA Admin and the Warehouse to US West Coast and set as default, then log in in the AWO Front End)

2. Click on Count menu entry
   Then click on Select Stock button

3. Open the Product parameter (by clicking on the magnifying glass) and filter by 'ale'
   Some products are shown

4. Remove the filter
   All the available products are shown
   This creates peformance problems in clients with lots of products

Proposed Solution

Limit the number of products that the system retrieves without filter or do not allow to show a list of products without filtering it first

Tags

FASH

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	design defect	0049559		closed	Triage Omni WMS	Openbravo ERP	Performance for product selection filter is KO with high volume of data in Inventory Count AWO
related to	design defect	0047336		new	Triage Omni WMS	Modules	in an environment with a lot of data the search in AWO does not work

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2022-06-22 15:59	XABIER_AGUADO	New Issue
2022-06-22 15:59	XABIER_AGUADO	Assigned To	=> Retail
2022-06-22 15:59	XABIER_AGUADO	Triggers an Emergency Pack	=> No
2022-06-22 16:12	rafaroda	Tag Attached: FASH
2022-06-22 16:12	rafaroda	Relationship added	related to 0049559
2022-06-22 16:12	rafaroda	Relationship added	related to 0047336
2022-06-23 12:59	marvintm	Assigned To	Retail => Triage Omni WMS