Christian Carlow created OFBIZ-6427:
---------------------------------------
Summary: Implement FindService record grouping/summarization
functionality
Key: OFBIZ-6427
URL: https://issues.apache.org/jira/browse/OFBIZ-6427
Project: OFBiz
Issue Type: Bug
Components: framework
Affects Versions: Trunk
Reporter: Christian Carlow
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)
