r7265 - dumbhippo/trunk/server/src/com/dumbhippo/server/impl

[commits mugshot org]

Author: otaylor
Date: 2008-01-25 17:41:39 -0600 (Fri, 25 Jan 2008)
New Revision: 7265

Modified:
   dumbhippo/trunk/server/src/com/dumbhippo/server/impl/StackerBean.java
Log:
Include nickname in native query result

Modified: dumbhippo/trunk/server/src/com/dumbhippo/server/impl/StackerBean.java
===================================================================
--- dumbhippo/trunk/server/src/com/dumbhippo/server/impl/StackerBean.java	2008-01-25 23:29:05 UTC (rev 7264)
+++ dumbhippo/trunk/server/src/com/dumbhippo/server/impl/StackerBean.java	2008-01-25 23:41:39 UTC (rev 7265)
@@ -1277,9 +1277,10 @@
 			blockTypeClause = "";
 			
 		Query q = em.createNativeQuery(
-				"SELECT STRAIGHT_JOIN u.* " +
+				"SELECT STRAIGHT_JOIN u.*, p.nickname " +
 				"     FROM UserBlockData ubd " +
 				"     JOIN HippoUser u on ubd.user_id = u.id " +
+				"     JOIN Person p on ubd.user_id = p.id " +
 				"     JOIN Block b on ubd.block_id = b.id " +
 				"    WHERE ubd.deleted = 0 AND ubd.participatedTimestamp IS NOT NULL" +
 				"      AND b.publicBlock = 1 " +