[OFBIZ-11069] Add coalesce to aggregate-function of model view

• Type: Improvement
• Status: Open
• Priority: Trivial
• Resolution: Unresolved
• Component/s: framework
• Labels: IoT ModelViewEntity
• Assignee: Unassigned
• Reporter: Shi Jinghai
• Created: 25/May/19 13:43
• Updated: 11/Jan/22 05:17

Description

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:

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