Openbravo Issue Tracking System - Modules
View Issue Details
0047336ModulesAdvanced Warehouse Operationspublic2021-07-06 09:082022-03-07 12:59
salvador_campanella 
Triage Omni WMS 
normalmajoralways
newopen 
5
 
 
0047336: in an environment with a lot of data the search in AWO does not work
in an environment with a lot of data, the search in AWO does not work
in an environment with a lot of data:

The search for the product using the selector. Trying to search by name or UPC doesn't work

* note: contact support team to access an environment with a lot of data
No tags attached.
has duplicate 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 defect 0049629 closed AtulOpenbravo Retail Modules Performance Issue in Inventory Count when loading all Products in parameters 
Issue History
2021-07-06 09:08salvador_campanellaNew Issue
2021-07-06 09:08salvador_campanellaAssigned To => Triage Finance
2021-07-06 09:08salvador_campanellaResolution time => 1624744800
2021-07-06 09:51vmromanosResolution time1624744800 =>
2021-07-06 09:51vmromanosNote Added: 0130155
2021-07-06 09:51vmromanosTypedefect => design defect
2022-02-24 16:08ffourcadeNote Added: 0135291
2022-03-07 12:59ivazquezNote Added: 0135501
2022-06-16 08:28vmromanosRelationship addedhas duplicate 0049559
2022-06-22 16:12rafarodaRelationship addedrelated to 0049629
2022-09-06 17:18caristuCategoryAdvance Warehouse Operations => Advanced Warehouse Operations

Notes
(0130155)
vmromanos   
2021-07-06 09:51   
Changed to Design Defect and removed resolution time.

This is a well known issue. The selector searches for many criterias at the same time by concatenating "ORs", which kills the performance. The solution will come with the AWO Frontend refactor where the UI will specify the criteria to use for filtering.

Meanwhile an adhoc solution should be applied to the affected customer. If they want to search by UPC, then change the query to filter only by UPC.
(0135291)
ffourcade   
2022-02-24 16:08   
Any update?
(0135501)
ivazquez   
2022-03-07 12:59   
Hello team,

Any update about this issue?

Regards,
Ignacio Vazquez