ofbiz error in building BETWEEN condition

Francesco R
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 13, 2014

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 ?

1 answer

0 votes
todor kolev May 20, 2014

Any success on this one?

Suggest an answer

Log in or Sign up to answer