Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009638Openbravo ERPA. Platformpublic2009-06-25 15:032009-07-10 10:46
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.40MP7 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009638: Product selector is slow when used via Enter key (direct search) with many rows.
DescriptionWhen invoking the product selector with enter to directly search for a product search key entered in the field it is very slow with many products.

Steps To ReproduceNeeded: database with many products
Goto sales Order
Create and save an order header
Goto lines
Press New
Enter i.e. 'hat' in the product field and press the enter key
The action works correctly but is very slow.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0009637 closed shuehner Product selector is slow when used via Enter key (direct search) with many rows. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-06-25 15:03shuehnerTypedefect => backport
2009-06-25 15:03shuehnerfix_in_branch => 2.40
2009-06-25 15:06hgbotCheckin
2009-06-25 15:06hgbotNote Added: 0017586
2009-06-25 15:06hgbotStatusscheduled => resolved
2009-06-25 15:06hgbotResolutionopen => fixed
2009-06-25 15:06hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/70842d526f719ce111adaa2125f5a47f4a2835a1 [^]
2009-06-25 15:15shuehnerNote Added: 0017588
2009-07-10 10:46sureshbabuStatusresolved => closed
2009-07-10 10:46sureshbabuNote Added: 0018085
2009-07-10 10:46sureshbabuFixed in Version => 2.40MP7

Notes
(0017586)
hgbot   
2009-06-25 15:06   
Repository: erp/stable/2.40
Changeset: 70842d526f719ce111adaa2125f5a47f4a2835a1
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Jun 25 15:06:44 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/70842d526f719ce111adaa2125f5a47f4a2835a1 [^]

Fixed 9638: Optimize product selector direct search (via enter key) with many products
- Limit resultset to <= 2 records as only count 0,1,2 and perhaps data of a single product is needed

---
M src/org/openbravo/erpCommon/info/Product.java
---
(0017588)
shuehner   
2009-06-25 15:15   
for QA: please test all three possible cases of this action.

a.) no row is found for the product value you entered (i.e. xx)
b.) exactly one row is found and the selector-popup is opened and closed immediately and the values are used in the calling page (i.e. hat)
c.) more than one row is found and the selector popup is opened and displays the products filtered by the partial name entered (i.e. b)
(0018085)
sureshbabu   
2009-07-10 10:46   
tested as per developer notes, working fine.