Openbravo Issue Tracking System - Retail Modules | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0033583 | Retail Modules | Web POS | public | 2016-08-01 18:54 | 2018-02-28 17:55 |
| Reporter | shuehner | ||||
| Assigned To | Sandrahuguet | ||||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | RR18Q2 | |||
| Merge Request Status | |||||
| Review Assigned To | marvintm | ||||
| OBNetwork customer | |||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0033583: OrderLoader does double query for ad_user related to a bp | ||||
| Description | OrderLoader does double query in this code here to first check -> are any related contacts + then query again to find the first contact in the list. Should be optimized to do a single query only to cover both topics if (!bp.getADUserList().isEmpty()) { String userHqlWhereClause = " usr where usr.businessPartner = :bp and usr.organization.id in (:orgs) order by username"; OBQuery<User> queryUser = OBDal.getInstance().createQuery(User.class, userHqlWhereClause); | ||||
| Steps To Reproduce | Trace queries done by that part of the code in OrderLoader.java Rewrite to not use 2 queries. I.e. only use 2nd query. | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | Performance | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2016-08-01 18:54 | shuehner | New Issue | |||
| 2016-08-01 18:54 | shuehner | Assigned To | => Retail | ||
| 2016-08-01 18:54 | shuehner | Triggers an Emergency Pack | => No | ||
| 2016-08-01 18:54 | shuehner | Tag Attached: Performance | |||
| 2018-02-07 13:20 | Sandrahuguet | Assigned To | Retail => Sandrahuguet | ||
| 2018-02-28 08:31 | Sandrahuguet | Review Assigned To | => marvintm | ||
| 2018-02-28 08:42 | hgbot | Checkin | |||
| 2018-02-28 08:42 | hgbot | Note Added: 0102862 | |||
| 2018-02-28 08:42 | hgbot | Status | new => resolved | ||
| 2018-02-28 08:42 | hgbot | Resolution | open => fixed | ||
| 2018-02-28 08:42 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/dba7db40d9b1056a066deec5be60fe31028dc83f [^] | ||
| 2018-02-28 17:55 | marvintm | Status | resolved => closed | ||
| 2018-02-28 17:55 | marvintm | Fixed in Version | => RR18Q2 | ||
| Notes | |||||
|
|
|||||
|
|
||||