http://ofbiz.116.s1.nabble.com/jira-Updated-OFBIZ-12051-Improve-makeRangeCondition-in-file-EntityDateFilterCondition-java-tp4762179.html
> Improve makeRangeCondition in file EntityDateFilterCondition.java
> -----------------------------------------------------------------
>
> Key: OFBIZ-12051
> URL:
https://issues.apache.org/jira/browse/OFBIZ-12051> Project: OFBiz
> Issue Type: Improvement
> Components: ALL COMPONENTS
> Affects Versions: Trunk
> Reporter: Leila Mekika
> Priority: Minor
> Fix For: Trunk
>
> Attachments: OFBIZ-12051-TESTSCREEN.txt, OFBIZ-12051.patch
>
>
> When using makeRangeCondition for a project, it seems that one case is not returned by the generated condition:
> When we have a value with both from and thrudate greater than given range
>
> How to test:
> * Create an agreement with fromDate = current year start date and endDate = current year end date in [agreement screen|
https://localhost:8443/accounting/control/EditAgreement]
> * Apply OFBIZ-12051-TESTSCREEN.patch to add a "range" field in agreement find screen which allow filtering using makeRangeCondition filter.
> Got to agreement [find screen|
https://localhost:8443/accounting/control/FindAgreement] and enter a range period in current year.
> * The newly created agreement does not appears in result list
>
> * Apply OFBIZ-12051.patch to add a "range" field in agreement find screen which allow filtering using makeRangeCondition filter.
> * Try again to search [agreements|
https://localhost:8443/accounting/control/FindAgreement] with the same range period.
> * The newly created agreement must appear