Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012010Openbravo ERP09. Financial managementpublic2010-01-19 18:272010-03-10 18:29
Reporternetworkb 
Assigned Torajagopal 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionProfessional Appliance
Product Versionpi 
Target Version2.50MP12Fixed in Versionpi 
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
Summary0012010: Account selector is slow with > 20.000 accounts
DescriptionAccount selector is slow with > 20.000 accounts. Account drop-down is taking too much values.
Steps To Reproduce1) Import CSV file with > 20.000 accounts.
2) Go to Information > Account.
3) Search

Takes too much time.
Proposed SolutionThis selector should be refactor somehow not to display a drop-down for the accounts.
Additional Information
TagsNo tags attached.
Relationships
related to defect 00119122.50MP11 closed rafaroda Platform problems with account combination selector 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-01-19 18:27rafarodaNew Issue
2010-01-19 18:27rafarodaAssigned To => eduardo_Argal
2010-01-19 18:31rafarodaRelationship addedrelated to 0011912
2010-01-21 11:46eduardo_ArgalNote Added: 0023704
2010-02-01 12:27networkbPrioritynormal => immediate
2010-02-01 12:27networkbTarget Version => 2.50MP12
2010-02-03 11:17rafarodaNote Added: 0023923
2010-02-03 11:17rafarodaReporterrafaroda => networkb
2010-02-03 11:17rafarodaAssigned Toeduardo_Argal => dalsasua
2010-02-03 17:09dalsasuaPriorityimmediate => urgent
2010-02-03 17:10dalsasuaStatusnew => scheduled
2010-02-03 17:10dalsasuaNote Added: 0023930
2010-02-03 17:10dalsasuafix_in_branch => pi
2010-02-16 07:11rajagopalAssigned Todalsasua => rajagopal
2010-02-17 12:02hgbotCheckin
2010-02-17 12:02hgbotNote Added: 0024477
2010-02-17 12:02hgbotStatusscheduled => resolved
2010-02-17 12:02hgbotResolutionopen => fixed
2010-02-17 12:02hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d01a4c3322d5199d1a1ad319b5a1d3eaf0527d73 [^]
2010-02-17 17:31dalsasuaNote Added: 0024507
2010-02-17 17:31dalsasuaStatusresolved => closed
2010-02-17 17:31dalsasuaFixed in Version => pi
2010-02-18 00:00anonymoussf_bug_id0 =>
2010-02-19 16:35hudsonbotCheckin
2010-02-19 16:35hudsonbotNote Added: 0024652
2010-03-10 18:29anonymoussf_bug_id => 2967986

Notes
(0023704)
eduardo_Argal   
2010-01-21 11:46   
It refers to valid combination selector.
The proposed solution would be to remove the combo for accounts and add the account selector. That will prevent of loading all the accounts as part of the content of the HTML
(0023923)
rafaroda   
2010-02-03 11:17   
David,

Please talk to Eduardo in order to properly schedule this OBPS issue.

Thanks.
(0023930)
dalsasua   
2010-02-03 17:10   
Programmed for next sprint.
(0024477)
hgbot   
2010-02-17 12:02   
Repository: erp/devel/pi
Changeset: d01a4c3322d5199d1a1ad319b5a1d3eaf0527d73
Author: Rajagopal Baskaran <rajagopal.baskaran <at> openbravo.com>
Date: Wed Feb 17 16:33:08 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/d01a4c3322d5199d1a1ad319b5a1d3eaf0527d73 [^]

Fixes issue 12010: Account selector is slow with more than 20.000

---
M src/org/openbravo/erpCommon/info/Account.html
M src/org/openbravo/erpCommon/info/Account.java
M src/org/openbravo/erpCommon/info/Account.xml
---
(0024507)
dalsasua   
2010-02-17 17:31   
Working fine!!
(0024652)
hudsonbot   
2010-02-19 16:35   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/d01a4c3322d5 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/d22bdcc83354 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16481.obx [^]