http://ofbiz.116.s1.nabble.com/jira-Updated-OFBIZ-5315-view-entity-complex-alias-field-name-bug-when-view-entities-reference-other-s-tp4643885.html
> view-entity complex-alias field name bug when view-entities reference other view-entities
> -----------------------------------------------------------------------------------------
>
> Key: OFBIZ-5315
> URL:
https://issues.apache.org/jira/browse/OFBIZ-5315> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: Release Branch 11.04
> Reporter: Christian Carlow
> Priority: Minor
> Fix For: Release Branch 11.04
>
> Attachments: ModelViewEntity.java.patch
>
>
> Field names used in complex-alias are named incorrectly when SQL statements are generated.
> The following complex alias:
> <alias name="quantity">
> <complex-alias operator="-">
> <complex-alias-field entity-alias="A" field="field1"/>
> <complex-alias-field entity-alias="B" field="field2"/>
> </complex-alias>
> </alias>
> Will result with the following generated SQL when A and B are also view-entities:
> SELECT (C.A.field1 + C.B.field2)