Author: bpapez
Date: Fri Nov 9 14:19:27 2007
New Revision: 19102
URL: https://svndev.jahia.net/websvn/listing.php?sc=3D1&rev=3D19102&repname=
=3Djahia
Log:
change select in findStagingFieldsIdInPageWithoutContainer to make it perfo=
rm
Modified:
trunk/core/src/java/org/jahia/hibernate/dao/JahiaFieldsDataDAO.java
Modified: trunk/core/src/java/org/jahia/hibernate/dao/JahiaFieldsDataDAO.ja=
va
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/trunk/core/src/java/o=
rg/jahia/hibernate/dao/JahiaFieldsDataDAO.java&rev=3D19102&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
--- trunk/core/src/java/org/jahia/hibernate/dao/JahiaFieldsDataDAO.java (or=
iginal)
+++ trunk/core/src/java/org/jahia/hibernate/dao/JahiaFieldsDataDAO.java Fri=
Nov 9 14:19:27 2007
@@ -491,9 +491,9 @@
List retVal =3D null;
String hql;
if (!withTypes) {
- hql =3D "select distinct f.comp_id.id from JahiaFieldsData f w=
here f.containerId=3D0 and f.comp_id.workflowState>=3D1 and f.pageId=3D? or=
der by f.comp_id.id";
+ hql =3D "select distinct f.comp_id.id from JahiaFieldsData f w=
here f.containerId=3D0 and f.comp_id.workflowState in (1,2,3) and f.pageId=
=3D? order by f.comp_id.id";
} else {
- hql =3D "select distinct f.comp_id.id,f.type from JahiaFieldsD=
ata f where f.containerId=3D0 and f.comp_id.workflowState>=3D1 and f.pageId=
=3D? order by f.comp_id.id";
+ hql =3D "select distinct f.comp_id.id,f.type from JahiaFieldsD=
ata f where f.containerId=3D0 and f.comp_id.workflowState in (1,2,3) and f.=
pageId=3D? order by f.comp_id.id";
}
if (containerID !=3D null) {
final HibernateTemplate template =3D getHibernateTemplate();
_______________________________________________
cvs_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/cvs_list
