[
https://issues.apache.org/jira/browse/OFBIZ-6427?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Christian Carlow updated OFBIZ-6427:
------------------------------------
Attachment: OFBIZ-6427-testforms.txt
The testforms attachement is the widget form definitions on which the screenshots are based.
Notice:
* FindOrderItem <auto-fields-entity> default-field-type="find-sort-group".
* FindOrderItem submit hide-show-details="false"
* ListOrderItem list-name="groupedList"
* ListOrderItem override-list-size="true" - this is a hack for performFindList to allow the list to be paged greater than page 0
* ListOrderItem performFindList result-list-map="groupedList"
> 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-testforms.txt, OFBIZ-6427.patch, Screenshot1.png, Screenshot2.png, Screenshot3.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)
Locked
