--- a/modules/org.openbravo.retail.giftcards/src/org/openbravo/retail/giftcards/ListGiftCard.java	2017-03-31 22:13:19.000000000 +0200
+++ b/modules/org.openbravo.retail.giftcards/src/org/openbravo/retail/giftcards/ListGiftCard.java	2017-05-09 08:17:22.641605000 +0200
@@ -22,11 +22,10 @@
   protected List<String> getQuery(JSONObject jsonsent) throws JSONException {
 
     String query = "select searchKey as _identifier, businessPartner.name as businessPartner$_identifier,"
-        + "  id as id ,"
-        + "  product.name as product$_identifier , "
+        + "  id as id ," + "  product.name as product$_identifier , "
         + "  searchKey as  searchKey, '' as giftCardType, ''  as allowPartialReturn , amount as amount"
         + "  from GCNV_GiftCardInst  where alertStatus <> 'C' and $readableSimpleCriteria and $activeCriteria and "
-        + " (businessPartner.name like :filter or searchKey like :filter)";
+        + " (lower(businessPartner.name) like lower(:filter) or lower(searchKey) like lower(:filter))";
 
     return Arrays.asList(new String[] { query });
   }