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 ?
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
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