Author: tdraier
Date: Tue Jun 12 15:27:44 2007
New Revision: 17546
URL: https://svndev.jahia.net/websvn/listing.php?sc=3D1&rev=3D17546&repname=
=3Djahia
Log:
optimized request with cast (JAHIA-1979)
Modified:
branches/JAHIA-5-0-SP-BRANCH/core/src/java/org/jahia/hibernate/dao/Jahi=
aFieldsDataDAO.java
Modified: branches/JAHIA-5-0-SP-BRANCH/core/src/java/org/jahia/hibernate/da=
o/JahiaFieldsDataDAO.java
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-5-0-SP=
-BRANCH/core/src/java/org/jahia/hibernate/dao/JahiaFieldsDataDAO.java&rev=
=3D17546&repname=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- branches/JAHIA-5-0-SP-BRANCH/core/src/java/org/jahia/hibernate/dao/Jahi=
aFieldsDataDAO.java (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/java/org/jahia/hibernate/dao/Jahi=
aFieldsDataDAO.java Tue Jun 12 15:27:44 2007
@@ -1044,7 +1044,7 @@
template.setFlushMode(HibernateTemplate.FLUSH_NEVER);
if (implicitDataConversion) {
String hql =3D "select distinct f.value, p.pageType, f.comp_id=
.workflowState from JahiaFieldsData f, JahiaPagesData p where f.comp_id.id=
=3D? and f.type=3D"+ContentFieldTypes.PAGE+ " and " +
- "f.comp_id.versionId>-1 and f.comp_id.workflowState>0 =
and f.comp_id.workflowState<=3D? and p.comp_id.workflowState>0 and p.comp_i=
d.workflowState<=3D? and f.value=3Dp.comp_id.id order by f.comp_id.workflow=
State desc";
+ "f.comp_id.versionId>-1 and f.comp_id.workflowState>0 =
and f.comp_id.workflowState<=3D? and p.comp_id.workflowState>0 and p.comp_i=
d.workflowState<=3D? and cast(f.value as integer)=3Dp.comp_id.id order by f=
.comp_id.workflowState desc";
try {
List list =3D template.find(hql, new Object[]{fieldId, wor=
kflowState, workflowState});
if (!list.isEmpty()) {
_______________________________________________
cvs_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/cvs_list
