[
https://issues.apache.org/jira/browse/OFBIZ-10579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16625396#comment-16625396
]
Suraj Khurana commented on OFBIZ-10579:
---------------------------------------
Thanks [~lektran] for the patch, I have done some slight modifications (majorly
in _EntityQuery_) in it as required.
This patch introduces a new class _EntityDateFilterDetector._ It is used to
check if condition object is instance of _EntityDateFilterCondition_ or an
_EntityExpr_ where the left hand side (e.g. fieldName) contains "fromDate"
(case insensitive). It will log warning ("Date filter detected in query
condition, ignoring request to cache") instead of caching with date condition.
This also improves performance as now after this patch, filtered records are
fetched from DB, instead of fetching records first and then using
filterByCondition (dateCondition) on them.
> Date filtered queries with caching should be restricted to cache
> ----------------------------------------------------------------
>
> Key: OFBIZ-10579
> URL: https://issues.apache.org/jira/browse/OFBIZ-10579
> Project: OFBiz
> Issue Type: Improvement
> Components: ALL APPLICATIONS
> Affects Versions: Upcoming Branch
> Reporter: Suraj Khurana
> Assignee: Suraj Khurana
> Priority: Major
> Attachments: OFBIZ-10579.patch
>
>
> As per discussion on Dev ML
> https://markmail.org/thread/3qnkihmsyhly3lsg
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
