[jira] Updated: (OFBIZ-3090) Resolve widget action entity caching with filter-by-date

["Bob Morley (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OFBIZ-3090?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bob Morley updated OFBIZ-3090:
------------------------------

    Attachment: OFBIZ-3090_ResolveWidgetActionEntityCachingByDate.patch

This is a small change that detects if the list finder is finding by entity using cache AND filter by date.  Normally this would prevent any caching (becuase the date changes); this fix does the database query without the date restriction, and then it applies the date filtering in the application code.

> Resolve widget action entity caching with filter-by-date
> --------------------------------------------------------
>
>                 Key: OFBIZ-3090
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3090
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: ALL COMPONENTS
>            Reporter: Bob Morley
>         Attachments: OFBIZ-3090_ResolveWidgetActionEntityCachingByDate.patch
>
>
> When you attempt to get a cached result in an action block with "filter-by-date" turned on, caching never occurs because the date/time changes with each request.  Recommended solution is when use-cache and filter-by-date are both true, we will create a condition w/o the date restriction, execute the (cachable) query, and then use the EntityUtil to filter by date.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.