0036018: receipts search in WEB POS is case sensitive for search's part referring to the document number

Description

receipts search in WEB POS is case sensitive for search's part referring to the document number

Steps To Reproduce

1-Enter to livebuilds terminal VBS-1.
2-Create and paid a recetipt where the business partner is not VBS Customer (this stops because the document prefix of this terminal is VBS1).
3-Enter to Receipts and search for "vbs". See that the generated ticket in the previous step is not shown because the search's part referring to the document number is case sensitive.

Proposed Solution

Attached is the .diff

Tags

No tags attached.

Attached Files

PaidReceiptsHeaderUpperDoc.diff [^] (732 bytes) 2017-05-16 22:12 [Show Content] [Hide Content]

--- a/src/org/openbravo/retail/posterminal/PaidReceiptsHeader.java	2017-03-31 23:13:22.000000000 +0200
+++ b/src/org/openbravo/retail/posterminal/PaidReceiptsHeader.java	2017-05-16 17:36:31.000000000 +0200
@@ -110,7 +110,7 @@
         + " and ord.obposIsDeleted = false ";
 
     if (!json.getString("filterText").isEmpty()) {
-      String hqlFilter = "ord.documentNo like :filterT1 or upper(ord.businessPartner.name) like upper(:filterT1)";
+      String hqlFilter = "upper(ord.documentNo) like upper(:filterT1) or upper(ord.businessPartner.name) like upper(:filterT1)";
       for (PaidReceiptsHeaderHook hook : paidReceiptHeaderHooks) {
         try {
           String hql = hook.exec(hqlFilter, json.getString("filterText"));

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2017-05-16 22:12	letcharren	New Issue
2017-05-16 22:12	letcharren	Assigned To	=> Retail
2017-05-16 22:12	letcharren	File Added: PaidReceiptsHeaderUpperDoc.diff
2017-05-16 22:12	letcharren	Triggers an Emergency Pack	=> No