0046077: Double upper case in the where clause searching by Name, search key or UPC

Openbravo Issue Tracking System - Retail Modules

View Issue Details

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 Version

Product Version

RR20Q3.4

Target Version

Fixed in Version

RR21Q2

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

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

related to	feature request	0046074		closed	ranjith_qualiantech_com	Models with multiple queries do not accept pagination by Id
related to	defect	0046082		closed	rqueralta	Remote search of the product with wrong order by