[jira] [Comment Edited] (OFBIZ-6427) Implement FindService record grouping/summarization functionality

["Christian Carlow (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OFBIZ-6427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14567470#comment-14567470 ] 

Christian Carlow edited comment on OFBIZ-6427 at 6/1/15 4:03 PM:
-----------------------------------------------------------------

Attached are some screenshots of the POC patch.

Multi-sort capability was provided with sort sequence dropdown where lowest number indicates first sort.  A sort direction dropdown was also provided with the sort sequence which is ascending by default.  If a sort sequence isn't chosen then the field is ignored.

If a sort sequence is chosen then it activates the group checking functionality.  Fields are set to be grouped with the group style dropdown and "group-row" is the only 1 available so far.  

Group functions are listed as table rows at the end of each find field row and have sequence dropdowns that activate the group function and specify the order in which they should appear in the group's summary field.  Function expression text boxes are provided for each group function sequence dropdowns so that end-users can control what appears for each specific grouping function.  By the expression text is 
{code}
"<name of function> ${functionValue}".  ${functionValue} 
{code} is replaced with whatever is calculated during the find service.

Right now the grouping functionality is integrated into FindServices.performFindList but may be provided as a separate function.


was (Author: ofbizzer):
Attached are some screenshots of the POC patch.

Multi-sort capability was provided with sort sequence dropdown where lowest number indicates first sort.  A sort direction dropdown was also provided with the sort sequence which is ascending by default.  If a sort sequence isn't chosen then the field is ignored.

If a sort sequence is chosen then it activates the group checking functionality.  Fields are set to be grouped with the group style dropdown and "group-row" is the only 1 available so far.  

Group functions are listed as table rows at the end of each find field row and have sequence dropdowns that activate the group function and specify the order in which they should appear in the group's summary field.  Function expression text boxes are provided for each group function sequence dropdowns so that end-users can control what appears for each specific grouping function.  By the expression text is "<name of function> ${functionValue}".  ${functionValue} is replaced with whatever is calculated during the find service.

Right now the grouping functionality is integrated into FindServices.performFindList but may be provided as a separate function.

> Implement FindService record grouping/summarization functionality
> -----------------------------------------------------------------
>
>                 Key: OFBIZ-6427
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-6427
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: Trunk
>            Reporter: Christian Carlow
>         Attachments: OFBIZ-6427_poc.patch, screen1.png, screen2.png
>
>
> Just as sortSeq and sortDir will be added to find fields like ignoreCase is available, groupBy check box would also enhance user query capabilities.  FindService would have to be extended to process the list and create group/summary records.
> For example, if a grid/form lists customer orders and the user wants to determine the total quantity and price of products ordered between a date range, then check marking the groupBy for productId would insert a grouping record before the details containing totals.
> This issue is primarily meant to handle reports for which pagination isn't used because all records are displayed.  For these reports queries, group totals can simply be calculated by looping each detail record.  But if pagination is used, the method of calculating totals for grouping records becomes more complicated because if detail records exist outside of the current page but are part of a group being summarized then they will be excluded from the group total unless implemented some other way.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)