0042269: [Performance] ProductCharacteristicValue master data performance improvement

diff --git a/src/org/openbravo/retail/posterminal/master/ProductCharacteristicValue.java b/src/org/openbravo/retail/posterminal/master/ProductCharacteristicValue.java
--- a/src/org/openbravo/retail/posterminal/master/ProductCharacteristicValue.java
+++ b/src/org/openbravo/retail/posterminal/master/ProductCharacteristicValue.java
@@ -21,8 +21,11 @@
 import org.codehaus.jettison.json.JSONArray;
 import org.codehaus.jettison.json.JSONException;
 import org.codehaus.jettison.json.JSONObject;
+import org.hibernate.Session;
+import org.hibernate.query.Query;
 import org.openbravo.client.kernel.ComponentProvider.Qualifier;
 import org.openbravo.dal.core.OBContext;
+import org.openbravo.dal.service.OBDal;
 import org.openbravo.mobile.core.model.HQLPropertyList;
 import org.openbravo.mobile.core.model.ModelExtension;
 import org.openbravo.mobile.core.model.ModelExtensionUtils;
@@ -52,6 +55,13 @@
     return propertiesList;
   }
 
+  private List<String> getUsedInWebPOSCharacteristics() {
+	  String hqlQuery = "select id from Characteristic c where c.obposUseonwebpos = true and isactive = 'Y'";
+	  final Session session = OBDal.getInstance().getSession();
+	  final Query<String> qry = session.createQuery(hqlQuery);
+	  return qry.list();
+  }
+  
   @Override
   protected Map<String, Object> getParameterValues(JSONObject jsonsent) throws JSONException {
     try {
@@ -71,6 +81,7 @@
       Map<String, Object> paramValues = new HashMap<String, Object>();
       paramValues.put("productListId", productList.getId());
       paramValues.put("priceListVersionId", priceListVersion.getId());
+      paramValues.put("characteristicIds", getUsedInWebPOSCharacteristics());
 
       // Optional filtering by a list of m_product_id
       if (jsonsent.getJSONObject("parameters").has("filterProductList")
@@ -86,7 +97,7 @@
       OBContext.restorePreviousMode();
     }
   }
-
+  
   @Override
   protected List<String> getQuery(JSONObject jsonsent) throws JSONException {
 
@@ -99,6 +110,8 @@
 
     HQLPropertyList regularProductsCharacteristicHQLProperties = ModelExtensionUtils
         .getPropertyExtensions(extensions);
+    
+    List<String> charList = getUsedInWebPOSCharacteristics();
 
     hqlQuery = "select " + regularProductsCharacteristicHQLProperties.getHqlSelect()
         + "from ProductCharacteristicValue pcv " + "inner join pcv.characteristic characteristic "
@@ -107,7 +120,7 @@
         + "inner join product.pricingProductPriceList ppp "
         + "where opp.obretcoProductlist.id= :productListId "
         + "and ppp.priceListVersion.id= :priceListVersionId "
-        + "and characteristic.obposUseonwebpos = true "
+        + "and characteristic.id in (:characteristicIds) "
         + "and pcv.$filtersCriteria AND pcv.$hqlCriteria "
         + "and pcv.$naturalOrgCriteria and pcv.$readableSimpleClientCriteria "
         + ((lastUpdated != null)