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 ?
SELECT myDate FROM myTable WHERE myDate BETWEEN ? AND ?;
But just now I found this link also
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 ?
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot