Hello Isomorphic,
After upgrading from 4.1 to 5.0, we notice that the fields included via customSQL are getting omitted from the selectClause.
1. === 2014-10-17 14:36:22,534 [main] INFO ISCInit - Isomorphic SmartClient/SmartGWT Framework (v10.0p_2014-10-10/PowerEdition Deployment 2014-10-10) - Initialization Complete
2. Browser: Firefox 24.4.0
The ds.xml file is as below:
The fields from other tables are getting omitted from the generated select statement:
=== 2014-10-17 14:36:57,090 [l0-3] INFO SQLDataSource - [builtinApplication.MODULE_ROLE_SECURITY_fetch] 98: Executing SQL query on 'Oracle': SELECT T_SRV_CONT_ROLES.FSE_SRV_ID, T_SRV_CONT_ROLES.CONT_ID, T_SRV_CONT_ROLES.ROLE_ID FROM
T_SRV_CONT_ROLES, T_MOD_CRUD_SECURITY, T_FSE_SERVICES
WHERE
T_SRV_CONT_ROLES.FSE_SRV_ID = T_FSE_SERVICES.FSE_SRV_ID AND
T_SRV_CONT_ROLES.ROLE_ID = T_MOD_CRUD_SECURITY.ROLE_ID AND
((T_SRV_CONT_ROLES.CONT_ID=4399))
This works fine in 4.1 and earlier. Is there any setting that we had missed?
After upgrading from 4.1 to 5.0, we notice that the fields included via customSQL are getting omitted from the selectClause.
1. === 2014-10-17 14:36:22,534 [main] INFO ISCInit - Isomorphic SmartClient/SmartGWT Framework (v10.0p_2014-10-10/PowerEdition Deployment 2014-10-10) - Initialization Complete
2. Browser: Firefox 24.4.0
The ds.xml file is as below:
Code:
<DataSource
dbName="Oracle"
tableName="T_SRV_CONT_ROLES"
ID="MODULE_ROLE_SECURITY"
dataSourceVersion="1"
serverType="sql"
>
<fields>
<field name="FSE_SRV_ID" primaryKey="true" type="number" hidden="true"></field>
<field name="CONT_ID" primaryKey="true" type="number" hidden="true"></field>
<field name="ROLE_ID" type="number"></field>
<field name="MOD_ID" type="number" customSQL="true" tableName="T_MOD_CRUD_SECURITY"></field>
<field name="FSE_SRV_IS_HYBRID" type="text" customSQL="true" tableName="T_FSE_SERVICES"></field>
<field name="FSE_SRV_ENABLE_SEED" type="text" customSQL="true" tableName="T_FSE_SERVICES"></field>
<field name="FSE_SRV_ENABLE_D_STAGING" type="text" customSQL="true" tableName="T_FSE_SERVICES"></field>
<field name="FSE_SRV_TYPE_ID" type="number" customSQL="true" tableName="T_FSE_SERVICES"></field>
<field name="FSE_SRV_TAG_GO" type="text" customSQL="true" tableName="T_FSE_SERVICES"></field>
</fields>
<operationBindings>
<operationBinding
operationType = "fetch"
customValueFields = "MOD_ID, FSE_SRV_IS_HYBRID, FSE_SRV_ENABLE_SEED, FSE_SRV_ENABLE_D_STAGING, FSE_SRV_TYPE_ID,
FSE_SRV_TAG_GO"
customCriteriaFields = "MOD_ID, FSE_SRV_IS_HYBRID, FSE_SRV_ENABLE_SEED, FSE_SRV_ENABLE_D_STAGING, FSE_SRV_TYPE_ID,
FSE_SRV_TAG_GO">
<tableClause>
T_SRV_CONT_ROLES, T_MOD_CRUD_SECURITY, T_FSE_SERVICES
</tableClause>
<whereClause>
T_SRV_CONT_ROLES.FSE_SRV_ID = T_FSE_SERVICES.FSE_SRV_ID AND
T_SRV_CONT_ROLES.ROLE_ID = T_MOD_CRUD_SECURITY.ROLE_ID AND
($defaultWhereClause)
</whereClause>
</operationBinding>
</operationBindings>
</DataSource>
=== 2014-10-17 14:36:57,090 [l0-3] INFO SQLDataSource - [builtinApplication.MODULE_ROLE_SECURITY_fetch] 98: Executing SQL query on 'Oracle': SELECT T_SRV_CONT_ROLES.FSE_SRV_ID, T_SRV_CONT_ROLES.CONT_ID, T_SRV_CONT_ROLES.ROLE_ID FROM
T_SRV_CONT_ROLES, T_MOD_CRUD_SECURITY, T_FSE_SERVICES
WHERE
T_SRV_CONT_ROLES.FSE_SRV_ID = T_FSE_SERVICES.FSE_SRV_ID AND
T_SRV_CONT_ROLES.ROLE_ID = T_MOD_CRUD_SECURITY.ROLE_ID AND
((T_SRV_CONT_ROLES.CONT_ID=4399))
This works fine in 4.1 and earlier. Is there any setting that we had missed?