[OFBIZ-6517] Form/Grid crosstab field type support

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: Trunk, Upcoming Branch
• Component/s: framework
• Sprint: Community Day 2 - 2015
• Assignee: Unassigned
• Reporter: Christian Carlow
• Created: 19/Jun/15 19:30
• Updated: 11/Jan/22 08:48

Description

Form/Grid widgets should be extended to support crosstab functionality:
https://en.wikipedia.org/wiki/Pivot_table

Option field types seem the best grid/form widget field types on which to base this functionality. For example:

<field name="facilityId">
    <crosstab current-description="${quantityOnHandTotal}">
        <list-options key-name="facilityId" list-name="facilitiesToPivot"/>
    </crosstab>
</field>

This would allow a list of facilitiesIds to be used as grid column titles with with cell values assigned to quantityOnHandTotal for records with facilityId matching that of the title.