view-entity complex-alias bug

[Christian Carlow-OFBizzer]

Hi,

Does anyone know if the problem in the following post was ever patched?

http://mail-archives.apache.org/mod_mbox/ofbiz-user/200909.mbox/[e-mail]%3E

Seems like important SQL functionality would be supported in OFBiz.

[Christian Carlow-OFBizzer]

In case anyone needs this functionality, figured it out myself.

Replace on line 990 of framework/entity/src/org/ofbiz/entity/model/ModelViewEntity.java:
        String colName = entityAlias + "." + modelField.getColName();
with:
       String colName = entityAlias + "." + SqlJdbcUtil.filterColName(modelField.getColName());

[Paul Foxworthy]

Hi OFBizzer,

Please create a Jira issue with a patch for this.

See https://cwiki.apache.org/OFBADMIN/ofbiz-contributors-best-practices.html for some guidance.

Cheers

Paul Foxworthy

OFBizzer wrote

In case anyone needs this functionality, figured it out myself.

Replace on line 990 of framework/entity/src/org/ofbiz/entity/model/ModelViewEntity.java:
        String colName = entityAlias + "." + modelField.getColName();
with:
       String colName = entityAlias + "." + SqlJdbcUtil.filterColName(modelField.getColName());