Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0024662 | Openbravo ERP | A. Platform | public | 2013-09-02 13:38 | 2013-10-18 12:55 |
|
| Reporter | egoitz | |
| Assigned To | alostale | |
| Priority | urgent | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | 3.0MP29 | Fixed in Version | 3.0MP29 | |
| Merge Request Status | |
| Review Assigned To | AugustoMauch |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0024662: When selecting a row on a pickandExecute a query to get the data selected is done |
| Description | When selecting a row on a pickandExecute a query to get the data selected is done.The select is not needed because you already have the data on the grid. |
| Steps To Reproduce | -Activate the log of postgresql to show queries that take more than 10ms
-Open the REturn from customer window
-Create a new row and save
-click on the pick and execute button
-The grid is shown
*See on the log the query executed
-Then select one row
*See on the log that a similar query filtered by the row selected is done
This happens becuase the request is done with action NEW but also including the rowId.
|
| Proposed Solution | |
| Additional Information | |
| Tags | Performance |
| Relationships | |
| Attached Files |  issue-24662.diff (1,009) 2013-09-26 16:08
https://issues.openbravo.com/file_download.php?file_id=6431&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2013-09-02 13:38 | egoitz | New Issue | |
| 2013-09-02 13:38 | egoitz | Assigned To | => AugustoMauch |
| 2013-09-02 13:38 | egoitz | Modules | => Core |
| 2013-09-02 13:38 | egoitz | Triggers an Emergency Pack | => No |
| 2013-09-02 13:38 | egoitz | Tag Attached: Performance | |
| 2013-09-03 11:10 | egoitz | Target Version | => 3.0MP28 |
| 2013-09-23 06:55 | shankarb | Assigned To | AugustoMauch => shankarb |
| 2013-09-25 13:30 | alostale | Assigned To | shankarb => alostale |
| 2013-09-26 16:02 | alostale | Note Added: 0061419 | |
| 2013-09-26 16:08 | alostale | File Added: issue-24662.diff | |
| 2013-09-26 16:08 | alostale | Note Added: 0061422 | |
| 2013-09-26 16:08 | alostale | Status | new => scheduled |
| 2013-09-26 16:08 | alostale | Target Version | 3.0MP28 => 3.0MP29 |
| 2013-09-30 12:00 | alostale | Review Assigned To | => shankarb |
| 2013-10-16 17:40 | shankarb | Review Assigned To | shankarb => AugustoMauch |
| 2013-10-16 17:40 | shankarb | Issue Monitored: AugustoMauch | |
| 2013-10-16 17:42 | hgbot | Checkin | |
| 2013-10-16 17:42 | hgbot | Note Added: 0061720 | |
| 2013-10-16 17:42 | hgbot | Status | scheduled => resolved |
| 2013-10-16 17:42 | hgbot | Resolution | open => fixed |
| 2013-10-16 17:42 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/77b44aa868e8e9b6ca315d62e8ef69c7c8465203 [^] |
| 2013-10-17 18:21 | hudsonbot | Checkin | |
| 2013-10-17 18:21 | hudsonbot | Note Added: 0061777 | |
| 2013-10-18 12:55 | AugustoMauch | Note Added: 0061802 | |
| 2013-10-18 12:55 | AugustoMauch | Status | resolved => closed |
| 2013-10-18 12:55 | AugustoMauch | Fixed in Version | => 3.0MP29 |
|
Notes |
|
|
|
When a row is selected FIC is called in NEW mode, this is correct and it is done to calculate defaults, callouts, combos, etc. In this case record id is passed as parameter and used to retrieve current element, for which we already have information in the client side.
In general retrieving current record by ID shouldn't be expensive, but in this case datasource is based in a view which has a perfomance impact.
Attached patch does not send id so FIC doesn't queries for current value. |
|
|
|
|
|
Attached patch for this issue, push scheduled for mp29 |
|
|
|
(0061720)
|
|
hgbot
|
|
2013-10-16 17:42
|
|
Repository: erp/devel/pi
Changeset: 77b44aa868e8e9b6ca315d62e8ef69c7c8465203
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Oct 16 21:11:45 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/77b44aa868e8e9b6ca315d62e8ef69c7c8465203 [^]
Fixes Issue 0024662: When selecting a row on a pickandExecute a query to get the data selected is done
---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/process/ob-pick-and-execute-grid.js
---
|
|
|
|
|
|
|
|
|
|
Code reviewed and verified in pi@eb0f3ecbdae4 |
|