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

[Nicolas Malin (Jira)]

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


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.

[Nicolas Malin (Jira)]

     [ 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.

[Nicolas Malin (Jira)]

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

Jacques Le Roux closed OFBIZ-3090.
----------------------------------

       Resolution: Fixed
    Fix Version/s: SVN trunk
                   Release Branch 9.04
         Assignee: Jacques Le Roux

Thanks Bob,

Your patch is in trunk at r832908, R9.04 at r832909

Please don't use tabs in your patches (only a litlle one in this one) If you use Eclipe, you may follow http://docs.ofbiz.org/display/OFBADMIN/Coding+Conventions to set it

> 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
>            Assignee: Jacques Le Roux
>             Fix For: Release Branch 9.04, SVN trunk
>
>         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.