Re: [xwiki-users] Modify recently changed documents panel

Hi Wouter, On 06/08/2011 11:45 AM, Wouter de Vos wrote: The quickest and less error prone solution for you is to edit the "Panels.Recently Modified" page and replace the first line: #set($recentlyModified = $xwiki.searchDocuments('where 1=1 order by doc.date desc', 5, 0)) with these two lines: #set($spaceList = ['Space1', 'Space2', $doc.space, 'GlobalSpace']) #set($recentlyModified = $xwiki.searchDocuments('where doc.web in (?, ?, ?, ?) order by doc.date desc', 5, 0, $spaceList)) Of course you should adjust the space list but make sure the number of ? (question marks) equals the number of spaces in the list). Hope this helps, Marius P.S: @developers: I tried to use the query manager as follows: #set($recentlyModified = $services.query.hql('select fullName from XWikiDocument where web in (:spaces) order by date desc').setLimit(5).setOffset(0).bindValue('spaces', $spaceList).execute()) but I get: Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: java.util.ArrayList cannot be cast to java.lang.String at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1087) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:1117) at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:88) ... 169 more We need to improve the XWikiHibernateBaseStore to support list parameters.