Mercurial > hg > openmind

changeset 22:165b1efb85cd

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
remove group-by clause for attribute search filter because it gave hibernate errors :-(
author casties
date Mon, 27 Jun 2016 19:09:37 -0400
parents 7af7a18e9573
children d2d4cd129f5e
files src/main/java/org/mpi/openmind/repository/services/PersistenceService.java
diffstat 1 files changed, 6 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/src/main/java/org/mpi/openmind/repository/services/PersistenceService.java	Mon Nov 30 17:43:04 2015 +0100
+++ b/src/main/java/org/mpi/openmind/repository/services/PersistenceService.java	Mon Jun 27 19:09:37 2016 -0400
@@ -1343,7 +1343,8 @@
 					.getCurrentSession();
 			session.getTransaction().begin();
 
-			String hql = "from Entity as ent, Attribute as att " + "where  "
+			String hql = "FROM Entity AS ent, Attribute AS att " 
+			        + "WHERE  "
 					+ "att.systemStatus = :systemStatus AND "
 					+ "ent.systemStatus = :systemStatus AND "
 					+ "ent.id = att.sourceId AND (";
@@ -1378,7 +1379,10 @@
 					hql += " OR ";
 			}
 
-			hql += " ) group by att.sourceId order by ent.ownValue";
+            /* ROC: led to hibernate errors
+             * hql += " ) group by att.sourceId order by ent.ownValue";
+             */
+            hql += " ) order by ent.ownValue";
 
 			Query query = session.createQuery(hql);
 			if (maxResult > 0)