You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Christian Carlow (JIRA)" <ji...@apache.org> on 2015/06/19 21:37:00 UTC

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

     [ https://issues.apache.org/jira/browse/OFBIZ-6517?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Christian Carlow updated OFBIZ-6517:
------------------------------------
    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:
{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.

  was:
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.


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