Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/ForumUserDao.java =================================================================== diff -u -raa6023fdecba00eb9a7df76e834e681f7d58462d -r5558dff6aabdd4eac2ad4cdd18ac749ef7d2002c --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/ForumUserDao.java (.../ForumUserDao.java) (revision aa6023fdecba00eb9a7df76e834e681f7d58462d) +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/ForumUserDao.java (.../ForumUserDao.java) (revision 5558dff6aabdd4eac2ad4cdd18ac749ef7d2002c) @@ -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"); }