ofbiz-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Christian Carlow (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OFBIZ-6427) Implement FindService record grouping/summarization functionality
Date Thu, 04 Jun 2015 14:33:38 GMT

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

Christian Carlow commented on OFBIZ-6427:
-----------------------------------------

XSDs updates are additional enhancements still needed.

Find fields now support these attributes:
*sort-by-seq - sets default sort seq dropdown value
group-by-style - sets default group by style
group-by-functions-map - sets the map used to populate default values for group functions
(Ex. sum seq and expr)
sort-group-by-options - accepts "find-sort" for unhiding sort fields and "find-sort-group"
for unhiding sort and group fields

auto-fields-entity XSD also needs to be updated with new defaultFieldType of "find-sort" and
"find-sort-group".

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

Mime
View raw message