Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0023889 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] A. Platform | major | have not tried | 2013-05-22 23:06 | 2014-06-25 01:35 | |||
Reporter | egoitz | View Status | public | |||||
Assigned To | AugustoMauch | |||||||
Priority | urgent | Resolution | fixed | Fixed in Version | 3.0MP24 | |||
Status | closed | Fix in branch | Fixed in SCM revision | 032fb3d55363 | ||||
Projection | none | ETA | none | Target Version | 3.0MP24 | |||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Review Assigned To | shankarb | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0023889: When searching on the field of a new selector the request to the datasource is done twice | |||||||
Description | When searching on the field of a new selector the request to the datasource is done twice. If there are less that 76 rows both request are done using limit $1 if there are more than 76 request the first request is using limit 76 and the second limit 76 offset 75 | |||||||
Steps To Reproduce | -Change the log of postgresql to see al the selects executed. -Open the sales order window -Openbravo the lines tab -Create a new row. -Write a value on the product field, for example a. *See that on the log there are two selects for the product selector | |||||||
Tags | Performance | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |||||||||||||||||||||||||||||
|
Notes | |
(0058986) hgbot (developer) 2013-05-28 12:46 |
Repository: erp/devel/pi Changeset: a569477afae52236a353f0cc4b906bc056ed0c32 Author: Augusto Mauch <augusto.mauch <at> openbravo.com> Date: Tue May 28 12:46:06 2013 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/a569477afae52236a353f0cc4b906bc056ed0c32 [^] Fixes issue 23889: No extra datasource calls are done by selectors Pick lists and grids use a property called drawAllMaxCells, that is used to determine how many cells should be fetched from the datasource, its default value is 250. If after making a datasource call smartclient finds out that the number of retrieved cells is lower than drawAllMaxCells, it will do another datasource call, and repeat this process until the number of cells fetched are higher than drawAllMaxCells or until all cells have been fetched. This is not the intented behaviour, we want the rows to be fetched when the user scrolls down and is out of cached rows. That is why in the definition of OBViewGrid the drawAllMaxCells is set to 0. To fix this issue this property is also set to 0 in the selector pick list and grid. --- M modules/org.openbravo.userinterface.selector/web/org.openbravo.userinterface.selector/js/ob-selector-item.js --- |
(0058987) AugustoMauch (administrator) 2013-05-28 12:51 |
Test plan: - Create a selector based on the c_country table - Create a new column in the c_uom table called c_country_id, varchar 32 - Add the column to the application dictionary and associate it with the new selector - Add the field to the application dictionary. - Compile and restart tomcat - Open the Unit of Measure window, open the debugger window - Create a new record - Empty the content of the c_country_id field, and press space. Check in the debugger that only one call to the Country table is done (before the fix 4 were done) - Open the selector grid. Check that only one call to the Country table is done (2 used to be done) |
(0059091) hudsonbot (developer) 2013-06-01 02:14 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/31f9b82dde77 [^] Maturity status: Test |
(0059117) shankarb (reporter) 2013-06-02 13:05 |
Code reviewed and tested in pi changeset f0878dbca750 |
(0068214) hgbot (developer) 2014-06-20 11:43 |
Repository: erp/devel/pi Changeset: 032fb3d553637702f5d14a6b0b2e8f8f23bf1c68 Author: Augusto Mauch <augusto.mauch <at> openbravo.com> Date: Fri Jun 20 11:42:57 2014 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/032fb3d553637702f5d14a6b0b2e8f8f23bf1c68 [^] Fixes issue 23889: Multiple requests to selector datasource in manual popups Pick lists and grids use a property called drawAllMaxCells, that is used to determine how many cells should be fetched from the datasource, its default value is 250. If after making a datasource call smartclient finds out that the number of retrieved cells is lower than drawAllMaxCells, it will do another datasource call, and repeat this process until the number of cells fetched are higher than drawAllMaxCells or until all cells have been fetched. This is not the intented behaviour, we want the rows to be fetched when the user scrolls down and is out of cached rows. This is achieved by setting drawAllMaxCells to 0. --- M modules/org.openbravo.userinterface.selector/web/org.openbravo.userinterface.selector/js/ob-selector-widget.js --- |
(0068215) AugustoMauch (administrator) 2014-06-20 11:44 |
This issue was reopened accidentally. |
(0068289) hudsonbot (developer) 2014-06-25 01:35 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/e78ccbaf0186 [^] Maturity status: Test |
Issue History | |||
Date Modified | Username | Field | Change |
2013-05-22 23:06 | egoitz | New Issue | |
2013-05-22 23:06 | egoitz | Assigned To | => AugustoMauch |
2013-05-22 23:06 | egoitz | Modules | => Core |
2013-05-22 23:06 | egoitz | Triggers an Emergency Pack | => No |
2013-05-22 23:06 | egoitz | Tag Attached: Performance | |
2013-05-22 23:58 | egoitz | Relationship added | related to 0023890 |
2013-05-23 00:00 | egoitz | Relationship added | related to 0023623 |
2013-05-23 02:06 | eintelau | Issue Monitored: eintelau | |
2013-05-28 12:38 | AugustoMauch | Issue Monitored: shankarb | |
2013-05-28 12:38 | AugustoMauch | Review Assigned To | => shankarb |
2013-05-28 12:46 | hgbot | Checkin | |
2013-05-28 12:46 | hgbot | Note Added: 0058986 | |
2013-05-28 12:46 | hgbot | Status | new => resolved |
2013-05-28 12:46 | hgbot | Resolution | open => fixed |
2013-05-28 12:46 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/a569477afae52236a353f0cc4b906bc056ed0c32 [^] |
2013-05-28 12:51 | AugustoMauch | Note Added: 0058987 | |
2013-06-01 02:14 | hudsonbot | Checkin | |
2013-06-01 02:14 | hudsonbot | Note Added: 0059091 | |
2013-06-02 13:05 | shankarb | Note Added: 0059117 | |
2013-06-02 13:05 | shankarb | Status | resolved => closed |
2013-06-02 13:05 | shankarb | Fixed in Version | => 3.0MP24 |
2014-06-20 10:13 | AugustoMauch | Relationship added | related to 0026911 |
2014-06-20 11:43 | hgbot | Checkin | |
2014-06-20 11:44 | hgbot | Note Added: 0068214 | |
2014-06-20 11:44 | hgbot | Status | closed => resolved |
2014-06-20 11:44 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/a569477afae52236a353f0cc4b906bc056ed0c32 [^] => http://code.openbravo.com/erp/devel/pi/rev/032fb3d553637702f5d14a6b0b2e8f8f23bf1c68 [^] |
2014-06-20 11:44 | AugustoMauch | Note Added: 0068215 | |
2014-06-20 11:44 | AugustoMauch | Status | resolved => closed |
2014-06-25 01:35 | hudsonbot | Checkin | |
2014-06-25 01:35 | hudsonbot | Note Added: 0068289 | |
2014-12-23 09:06 | alostale | Relationship added | related to 0028472 |
Copyright © 2000 - 2009 MantisBT Group |