Openbravo Issue Tracking System - Retail Modules | |||||||||||||||||||
| View Issue Details | |||||||||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||||||||||||
| 0046077 | Retail Modules | Web POS | public | 2021-03-15 17:10 | 2021-03-22 08:52 | ||||||||||||||
| Reporter | jetxarri | ||||||||||||||||||
| Assigned To | rqueralta | ||||||||||||||||||
| Priority | high | Severity | major | Reproducibility | always | ||||||||||||||
| Status | closed | Resolution | fixed | ||||||||||||||||
| Platform | OS | 5 | OS Version | ||||||||||||||||
| Product Version | RR20Q3.4 | ||||||||||||||||||
| Target Version | Fixed in Version | RR21Q2 | |||||||||||||||||
| Merge Request Status | |||||||||||||||||||
| Review Assigned To | marvintm | ||||||||||||||||||
| OBNetwork customer | Gold | ||||||||||||||||||
| Support ticket | |||||||||||||||||||
| Regression level | |||||||||||||||||||
| Regression date | |||||||||||||||||||
| Regression introduced in release | |||||||||||||||||||
| Regression introduced by commit | |||||||||||||||||||
| Triggers an Emergency Pack | No | ||||||||||||||||||
| Summary | 0046077: Double upper case in the where clause searching by Name, search key or UPC | ||||||||||||||||||
| Description | The problem happens when the user works with cache not initialized. If the user tries to find a product by "Name, search key or UPC" the result will create the following query "SimpleQueryBuilder --> getPart method": ..... or upper(upper(product3_.UPC)) like upper($2) ...... 2 concatenated upper cases | ||||||||||||||||||
| Steps To Reproduce | -Login into Web POS -Press "search" -Introduce a value in field "Name, search key or UPC" <-- Cache should not be initialized to force to do a remote search of the product. The problem is that loaded property in the model is add(new HQLProperty("upper(product.uPCEAN)", "uPCEAN")); instead of add(new HQLProperty("product.uPCEAN", "uPCEAN")); As it is possible to see in file ProductProperties | ||||||||||||||||||
| Proposed Solution | |||||||||||||||||||
| Additional Information | |||||||||||||||||||
| Tags | NOR | ||||||||||||||||||
| Relationships |
| ||||||||||||||||||
| Attached Files | |||||||||||||||||||
| Issue History | |||||||||||||||||||
| Date Modified | Username | Field | Change | ||||||||||||||||
| 2021-03-15 17:10 | jetxarri | New Issue | |||||||||||||||||
| 2021-03-15 17:10 | jetxarri | Assigned To | => Retail | ||||||||||||||||
| 2021-03-15 17:10 | jetxarri | Triggers an Emergency Pack | => No | ||||||||||||||||
| 2021-03-15 17:30 | rafaroda | OBNetwork customer | => Gold | ||||||||||||||||
| 2021-03-15 17:30 | rafaroda | Resolution time | => 1617141600 | ||||||||||||||||
| 2021-03-15 17:30 | rafaroda | Severity | minor => major | ||||||||||||||||
| 2021-03-15 17:31 | rafaroda | Tag Attached: NOR | |||||||||||||||||
| 2021-03-15 17:31 | rafaroda | Relationship added | related to 0046074 | ||||||||||||||||
| 2021-03-16 13:21 | shuehner | Relationship added | related to 0046082 | ||||||||||||||||
| 2021-03-16 20:05 | rqueralta | Assigned To | Retail => rqueralta | ||||||||||||||||
| 2021-03-16 20:05 | rqueralta | Status | new => scheduled | ||||||||||||||||
| 2021-03-22 08:52 | marvintm | Note Added: 0126815 | |||||||||||||||||
| 2021-03-22 08:52 | marvintm | Status | scheduled => resolved | ||||||||||||||||
| 2021-03-22 08:52 | marvintm | Fixed in Version | => RR21Q2 | ||||||||||||||||
| 2021-03-22 08:52 | marvintm | Resolution | open => fixed | ||||||||||||||||
| 2021-03-22 08:52 | marvintm | Review Assigned To | => marvintm | ||||||||||||||||
| 2021-03-22 08:52 | marvintm | Status | resolved => closed | ||||||||||||||||
| Notes | |||||
|
|
|||||
|
|
||||