[jira] [Commented] (OFBIZ-5315) view-entity complex-alias field name bug when view-entities reference other view-entities

["Mridul Pathak (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OFBIZ-5315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18083720#comment-18083720 ] 

Mridul Pathak commented on OFBIZ-5315:
--------------------------------------

I have verified that the issue exist and tested the attached patch which correctly fixes the issue. Created PRs using the attached patch.

> 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
>            Assignee: Mridul Pathak
>            Priority: Minor
>         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) 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)