[jira] [Commented] (OFBIZ-6517) Form/Grid crosstab field type support

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

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

Christian Carlow commented on OFBIZ-6517:
-----------------------------------------

Here is an example of how the crosstab-find may be used:

{code}
<field name="facilityId">
    <crosstab-find column-field="quantityOnHandTotal" find-field-type="TextFindField">
        <list-options key-name="facilityId" list-name="facilitiesToPivot"/>
    </crosstab-find>
</field>
{code}

> Form/Grid crosstab field type support
> -------------------------------------
>
>                 Key: OFBIZ-6517
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-6517
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: Trunk
>            Reporter: Christian Carlow
>            Priority: Minor
>         Attachments: OFBIZ-6517.patch
>
>
> 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:
> {code}
> <field name="facilityId">
>     <crosstab current-description="${quantityOnHandTotal}">
>         <list-options key-name="facilityId" list-name="facilitiesToPivot"/>
>     </crosstab>
> </field>
> {code}
> 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.



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