Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0046077 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | major | always | 2021-03-15 17:10 | 2021-03-22 08:52 | |||
| Reporter | jetxarri | View Status | public | |||||
| Assigned To | rqueralta | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | RR21Q2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | RR20Q3.4 | SCM revision | ||||||
| Review Assigned To | marvintm | |||||||
| 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 | |||||||
| Tags | NOR | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0126815) marvintm (manager) 2021-03-22 08:52 |
This issue has been fixed by the change in issue https://issues.openbravo.com/view.php?id=46082 [^] https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/merge_requests/192/diffs [^] |
|
Notes |
|
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 | 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |