[jira] [Created] (OFBIZ-11069) Add coalesce to aggregate-function of model view

[Nicolas Malin (Jira)]

Shi Jinghai created OFBIZ-11069:
-----------------------------------

             Summary: Add coalesce to aggregate-function of model view
                 Key: OFBIZ-11069
                 URL: https://issues.apache.org/jira/browse/OFBIZ-11069
             Project: OFBiz
          Issue Type: Improvement
          Components: framework
            Reporter: Shi Jinghai
             Fix For: Trunk
         Attachments: ModelViewEntity-function-coalesce.patch

While in our IoT case, a product may have a sku product id as well as a productId (product instance) by identified from unique id i.e. an EPC.

When building operation/inventory reports, to be compatible with previous implement, I have to merge the sku product Id column into the productId column, so comes the coalesce patch. 

The usage example:
{code:java}
<alias entity-alias="IID" name="productId" group-by="true" function="coalesce">
    <complex-alias operator=",">
        <complex-alias-field entity-alias="IID" field="skuProductId"/>
        <complex-alias-field entity-alias="IID" field="productId"/>
    </complex-alias>
</alias>
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)