Index: lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardSessionDAO.java
===================================================================
diff -u -r6e90b353c748e631a60d48a15aaf880f026042ce -r172c5ffb1db24453fad76331b77279e694d1602a
--- lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardSessionDAO.java	(.../NoticeboardSessionDAO.java)	(revision 6e90b353c748e631a60d48a15aaf880f026042ce)
+++ lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardSessionDAO.java	(.../NoticeboardSessionDAO.java)	(revision 172c5ffb1db24453fad76331b77279e694d1602a)
@@ -23,6 +23,7 @@
 
 import java.util.List;
 import org.lamsfoundation.lams.tool.noticeboard.NoticeboardSession;
+import org.lamsfoundation.lams.tool.noticeboard.NoticeboardContent;
 import org.lamsfoundation.lams.tool.noticeboard.NoticeboardUser;
 import org.lamsfoundation.lams.tool.noticeboard.dao.INoticeboardSessionDAO;
 import org.springframework.orm.hibernate.support.HibernateDaoSupport;
@@ -40,6 +41,10 @@
 	
     private static final String LOAD_NBSESSION_BY_USER = "select ns from NoticeboardSession ns left join fetch "
         + "ns.nbUsers user where user.userId=:userId";
+    
+    private static final String GET_SESSIONS_FROM_CONTENT = "select ns.nbSessionId from NoticeboardSession ns where ns.nbContent= :nbContent";
+    
+    
 
     
     /**
@@ -188,5 +193,12 @@
 	    this.getHibernateTemplate().saveOrUpdate(user);
 	    this.getHibernateTemplate().saveOrUpdateCopy(session);	    
 	}
+	
+	public List getSessionsFromContent(NoticeboardContent nbContent)
+	{
+	    return (getHibernateTemplate().findByNamedParam(GET_SESSIONS_FROM_CONTENT,
+	            "nbContent",
+				nbContent));
+	}
     	
 }