# HG changeset patch
# User casties
# Date 1467068977 14400
# Node ID 165b1efb85cd61d63729643bb2e3ff7b6a76c4ae
# Parent  7af7a18e9573f9f180b0532a079c997c75aabb74
remove group-by clause for attribute search filter because it gave hibernate errors :-(

diff -r 7af7a18e9573 -r 165b1efb85cd src/main/java/org/mpi/openmind/repository/services/PersistenceService.java
--- 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)