# HG changeset patch
# User Rafa Alonso <ral@openbravo.com>
# Date 1470917662 18000
#      jue ago 11 07:14:22 2016 -0500
# Branch laeuropea
# Node ID 87ca72a63559893a6a370a33967012352b7760de
# Parent  3f539f7f1234a015aa7a6b07cbc9c23cdaa77484
[hotfix] Fixes issue 33690: With big data, searching for a receipt is slow

diff -r 3f539f7f1234 -r 87ca72a63559 src/org/openbravo/retail/posterminal/PaidReceiptsHeader.java
--- a/src/org/openbravo/retail/posterminal/PaidReceiptsHeader.java	jue jun 02 09:09:26 2016 +0200
+++ b/src/org/openbravo/retail/posterminal/PaidReceiptsHeader.java	jue ago 11 07:14:22 2016 -0500
@@ -87,7 +87,7 @@ public class PaidReceiptsHeader extends 
         + "' and ord.obposIsDeleted = false ";
 
     if (!json.getString("filterText").isEmpty()) {
-      String hqlFilter = "ord.documentNo like :filterT1 or REPLACE(ord.documentNo, '/', '') like :filterT1 or upper(ord.businessPartner.name) like upper(:filterT1)";
+      String hqlFilter = "ord.documentNo like :filterT1 or REPLACE(ord.documentNo, '/', '') like :filterT1)";
       for (PaidReceiptsHeaderHook hook : paidReceiptHeaderHooks) {
         try {
           String hql = hook.exec(hqlFilter, json.getString("filterText"));