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)
