Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009637Openbravo ERPA. Platformpublic2009-06-25 15:032009-07-23 00:00
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.50MP3 
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
Summary0009637: 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
Tags250MP3releasecandidate, leo
Relationships
depends on backport 0009638 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:03shuehnerNew Issue
2009-06-25 15:03shuehnerAssigned To => shuehner
2009-06-25 15:03shuehnerStatusnew => scheduled
2009-06-25 15:03shuehnerfix_in_branch => pi
2009-06-25 15:05hgbotCheckin
2009-06-25 15:05hgbotNote Added: 0017585
2009-06-25 15:05hgbotStatusscheduled => resolved
2009-06-25 15:05hgbotResolutionopen => fixed
2009-06-25 15:05hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/858c73b68f2c2a83aa232007295484bcbca9e7a1 [^]
2009-06-25 15:15shuehnerNote Added: 0017587
2009-07-21 16:24psarobeFixed in Version => 2.50MP3
2009-07-21 16:26psarobeTag Attached: 250MP3releasecandidate
2009-07-21 18:43psarobeTag Attached: leo
2009-07-22 06:11elopioStatusresolved => closed
2009-07-23 00:00anonymoussf_bug_id0 => 2825604

Notes
(0017585)
hgbot   
2009-06-25 15:05   
Repository: erp/devel/pi
Changeset: 858c73b68f2c2a83aa232007295484bcbca9e7a1
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Jun 25 15:05:11 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/858c73b68f2c2a83aa232007295484bcbca9e7a1 [^]

Fixed 9637: 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
---
(0017587)
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)