#14 Bad SQL generated for nested view-entities

[David E. Jones]

Bad SQL is generated for nested view-entities such as ExampleFeatureAndApplAndEnum which has the view-entity ExampleFeatureApplAndEnum as a member-entity.

The error from a find with this nested view-entity is:

Error rendering screen [component://tools/screen/Tools/AutoScreen/AutoFind.xml]: org.moqui.entity.EntityException: SQL Exception with statement:SELECT EFAAE.ENUM.DESCRIPTION, EXFT.EXAMPLE_FEATURE_ID, EXFT.FEATURE_SOURCE_ENUM_ID, EXFT.DESCRIPTION FROM (MOQUI.EXAMPLE_FEATURE EXFT INNER JOIN (SELECT EXFTAP.EXAMPLE_ID AS EXFTAP_EXAMPLE_ID, EXFTAP.EXAMPLE_FEATURE_ID AS EXFTAP_EXAMPLE_FEATURE_ID, EXFTAP.FROM_DATE AS EXFTAP_FROM_DATE, EXFTAP.THRU_DATE AS EXFTAP_THRU_DATE, EXFTAP.EXAMPLE_FEATURE_APPL_ENUM_ID AS EXFTAP_EXAMPLE_FEATURE_APPL_ENUM_ID, EXFTAP.SEQUENCE_NUM AS EXFTAP_SEQUENCE_NUM, ENUM.ENUM_ID AS ENUM_ENUM_ID, ENUM.ENUM_TYPE_ID AS ENUM_ENUM_TYPE_ID, ENUM.PARENT_ENUM_ID AS ENUM_PARENT_ENUM_ID, ENUM.ENUM_CODE AS ENUM_ENUM_CODE, ENUM.DESCRIPTION AS ENUM_DESCRIPTION FROM (MOQUI.EXAMPLE_FEATURE_APPL EXFTAP INNER JOIN MOQUI.ENUMERATION ENUM ON EXFTAP.EXAMPLE_FEATURE_APPL_ENUM_ID = ENUM.ENUM_ID)) EFAAE ON EXFT.EXAMPLE_FEATURE_ID = EFAAE.EXFTAP_EXAMPLE_FEATURE_ID) OFFSET 0 ROWS FETCH FIRST 50 ROWS ONLY; java.sql.SQLSyntaxErrorException: Column 'EFAAE.ENUM.DESCRIPTION' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'EFAAE.ENUM.DESCRIPTION' is not a column in the target table.