Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/ForumUserDao.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/ForumUserDao.java,v diff -u -r1.16 -r1.17 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/ForumUserDao.java 5 May 2016 08:08:59 -0000 1.16 +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/ForumUserDao.java 9 May 2016 02:15:02 -0000 1.17 @@ -150,14 +150,14 @@ } } + // If filtering by name add a name based where clause (LDEV-3779: must come before the Notebook JOIN statement) + buildNameSearch(queryText, searchString); + // If using notebook, add the notebook join if (notebookEntryStrings != null) { queryText.append(notebookEntryStrings[1]); } - // If filtering by name add a name based where clause - buildNameSearch(queryText, searchString); - if (sortOnMessage) { queryText.append(" GROUP BY user.user_id"); }