Author: clee
Date: 2007-03-22 08:29:40 -0800 (Thu, 22 Mar 2007)
New Revision: 3813
URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=3813
Modified:
trunk/src/org/hyperic/hq/authz/server/session/ResourceGroupDAO.java
Log:
[HQ-603]
Fix HQL that did not return results for available groups for role
Modified: trunk/src/org/hyperic/hq/authz/server/session/ResourceGroupDAO.java
===================================================================
--- trunk/src/org/hyperic/hq/authz/server/session/ResourceGroupDAO.java 2007-03-22 15:46:07 UTC (rev 3812)
+++ trunk/src/org/hyperic/hq/authz/server/session/ResourceGroupDAO.java 2007-03-22 16:29:40 UTC (rev 3813)
@@ -150,9 +150,7 @@
{
return getSession()
.createQuery("from ResourceGroup g " +
- "join fetch g.roles r " +
- "where r.id = ? and g.id not in " +
- "(select id from r.resourceGroups) and " +
+ "where ? not in (select id from g.roles) and " +
"g.system = false order by g.sortName " +
(asc ? "asc" : "desc"))
.setInteger(0, roleId.intValue())
|
