Hello, In the more recent 13.1 builds, I’ve noticed WARN messages like the following:
These seem harmless, but I’d like to understand more about their meaning.
Then, there are others like:
In some cases, these seem related to a regression in at least one specific operationBinding. After this warning, the criteria for that field doesn’t appear in the WHERE clause, whereas previously it did.
The field is defined as:
And the operationBinding includes it in the customCriteriaFields:
There’s one caveat: the DMI is actually calling dsRequest.addToCriteria() to add the criteria for the ID_ROLE_FK field.
Please let me know if this sheds some light, or if I should try to create a test case (though that might be difficult).
Code:
WARN SQLExpressions SQLExpression for field 'EMAIL' already exists, skip.
Then, there are others like:
Code:
WARN SQLExpressions Missing expression for the 'ID_ROLE_FK' field of the 'AUTH_MENU_ROLES_PERMISSIONS' DataSource.
The field is defined as:
Code:
<field name="ID_ROLE_FK" type="integer" customSelectExpression="MENU_ROLES.ID_ROLE_FK" customSQL="true"/>
Code:
<operationBinding operationType="fetch" operationId="fetchMenuPerGestioneUtenti" serverMethod="fetchMenuPerGestioneUtenti" requiresRole="ROLE_ADMIN, ROLE_USERADMIN, ROLE_ADMIN_SCOUT, ADMIN" customFields="IS_MENU_FROM_ROLE,IS_MENU_FROM_PERMISSION,ID_ROLES,ROLE_NAMES,ID_PERMISSIONS,PERMISSION_NAMES" customCriteriaFields="ID_PERMISSION_FK,ID_ROLE_FK"> <serverObject lookupStyle="new" className="com.juve.auth.menu.FetchMenuPerGestioneUtenti"/> <tableClause> $defaultTableClause LEFT JOIN DBJFRAME.AUTH_MENU_ROLES MENU_ROLES ON TREE_MENU.ID_REC = MENU_ROLES.ID_MENU_FK LEFT JOIN DBJFRAME.AUTH_ROLES ROLES ON MENU_ROLES.ID_ROLE_FK = ROLES.ID_REC LEFT JOIN DBJFRAME.AUTH_MENU_PERMISSIONS MENU_PERMISSIONS ON TREE_MENU.ID_REC = MENU_PERMISSIONS.ID_MENU_FK LEFT JOIN DBJFRAME.AUTH_PERMISSIONS PERMISSIONS ON MENU_PERMISSIONS.ID_PERMISSION_FK = PERMISSIONS.ID_REC </tableClause> <whereClause> $defaultWhereClause #if ($sessionAttributes.appID != 'JcaAuth') and TREE_MENU.ID_APP = $sessionAttributes.appID #end </whereClause> <groupBy>ID_REC</groupBy> <groupBy>ID_APP</groupBy> <groupBy>VOCE_MENU</groupBy> <groupBy>VOCE_MENU_EN</groupBy> <groupBy>ID_FUNZIONE</groupBy> <groupBy>ORDINAMENTO_PER_LIVELLO</groupBy> <groupBy>ID_VOCE_PADRE</groupBy> <groupBy>ICONA</groupBy> <groupBy>ICONA_SVG</groupBy> <groupBy>IS_MENU_FROM_ROLE</groupBy> <groupBy>IS_MENU_FROM_PERMISSION</groupBy> <groupBy>ID_MENU_FK</groupBy> <summaryFunctions> <ID_ROLES>concat</ID_ROLES> <ROLE_NAMES>concat</ROLE_NAMES> <ID_PERMISSIONS>concat</ID_PERMISSIONS> <PERMISSION_NAMES>concat</PERMISSION_NAMES> <IS_DASHBOARD_VISIBLE>max</IS_DASHBOARD_VISIBLE> <MOBILE_PHONE_VISIBLE>max</MOBILE_PHONE_VISIBLE> <TABLET_VISIBLE>max</TABLET_VISIBLE> <MOBILE_PHONE_DEFAULT>max</MOBILE_PHONE_DEFAULT> <MOBILE_PHONE_ONLY>max</MOBILE_PHONE_ONLY> </summaryFunctions> <orderClause>ORDINAMENTO_PER_LIVELLO</orderClause> </operationBinding>
Please let me know if this sheds some light, or if I should try to create a test case (though that might be difficult).
Comment