[OpenbravoERP-commits] devel/pi: Added support for inSet and notInSet in advanced query...

[hg]

details:   https://code.openbravo.com/erp/devel/pi/rev/d488d55f07d4
changeset: 13768:d488d55f07d4
user:      Martin Taal <martin.taal <at> openbravo.com>
date:      Tue Sep 13 13:28:10 2011 +0200
summary:   Added support for inSet and notInSet in advanced querying/filter 
expressions

diffstat:

 
modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
 |  8 ++++++++
 1 files changed, 8 insertions(+), 0 deletions(-)

diffs (25 lines):

diff -r c6ad9f63b560 -r d488d55f07d4 
modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
--- 
a/modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
       Tue Sep 13 12:48:47 2011 +0200
+++ 
b/modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
       Tue Sep 13 13:28:10 2011 +0200
@@ -323,6 +323,10 @@
 
     String rightClause = buildRightClause(property, operator, value);
 
+    if (hqlOperator.equals("in")) {
+      rightClause = "(" + rightClause + ")";
+    }
+
     if (isNot(operator)) {
       return "not(" + leftClause + " " + hqlOperator + " " + rightClause + ")";
     } else {
@@ -624,6 +628,10 @@
   private String getHqlOperator(String operator) {
     if (operator.equals(OPERATOR_EQUALS)) {
       return "=";
+    } else if (operator.equals(OPERATOR_INSET)) {
+      return "in";
+    } else if (operator.equals(OPERATOR_NOTINSET)) {
+      return "in";
     } else if (operator.equals(OPERATOR_NOTEQUAL)) {
       return "!=";
     } else if (operator.equals(OPERATOR_IEQUALS)) {

------------------------------------------------------------------------------
BlackBerry&reg; DevCon Americas, Oct. 18-20, San Francisco, CA
Learn about the latest advances in developing for the 
BlackBerry&reg; mobile platform with sessions, labs & more.
See new tools and technologies. Register for BlackBerry&reg; DevCon today!
http://p.sf.net/sfu/rim-devcon-copy1 
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits