[Hyperic-hq-discuss] hq r3813 - trunk/src/org/hyperic/hq/authz/server/session

[<cl...@hy...>]

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())