Mercurial > hg > openmind
diff src/main/java/org/mpi/openmind/repository/services/PersistenceService.java @ 22:165b1efb85cd
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 | 615d27dce9b3 |
children | 5e24413d355b |
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)