Hello, I need help in trying to understand if the BETWEEN condition is correctly built or not.
According the https://issues.apache.org/jira/browse/OFBIZ-1121the uncorrect building of the sql query with a BETWEEN condition has been solved.
But I'm still experiencing problems.
I'm using JIRA 6.1.3 and I think the OfBiz version used is in entityengine-1.0.40.jar
Then I followed the source in debugging and in the source code the sql query was not correctly formatted. It returns a SQL string like
SELECT myDate FROM myTable WHERE myDate BETWEEN ?
instead of
SELECT myDate FROM myTable WHERE myDate BETWEEN ? AND ?;
But just now I found this link also
https://fisheye6.atlassian.com/browse/ofbiz/trunk/framework/entity/src/org/ofbiz/entity/condition/EntityExpr.java?r=1490541
with something that maybe could work but it's not in the currently running entityengine jar file
My java (not working) code is the following:
List criteria = new LinkedList(); criteria.add(beginDate); criteria.add(endDate); betweenConditionList.add(new EntityExpr(betweenFields[i], EntityOperator.BETWEEN, criteria));
So, how can I get the BETWEEN condition working ? With which version ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.