Thank you Jean-Vincent, I'll try the code out once I've figured it out. It would be useful to have someone who 'knows' to document/write one or more tutorials on how to extract information from the XWiki database. It would help XWiki users/developers to develop XWiki for all sort of applications: * Task/process generation and tracking * Work flow form based applications * Issue tracking * Help desk request/issue tracking * Objective setting and planning etc Regards, Richard -----Original Message----- From: devs-bounces(a)xwiki.org [mailto:devs-bounces@xwiki.org]On Behalf Of Jean-Vincent Drean Sent: 03 October 2007 14:38 To: XWiki Developers Subject: Re: [xwiki-devs] Ref: Displaying lists of wiki pages given a set of criteria Hi, It's a recurrent need but AFAIK we don't have any generic solution. I've made a 5' snippet, hope it will be useful. This snippet requires programming rights ($xwiki.xWiki.search) so you'll have to make sure that simple users can't edit this page. -----------------------------------------------8<--------------------------- ---------------------------------------- #macro(paginedSearch $query $currentPage $resultsPerPage) #set ($start = $resultsPerPage * $currentPage) #set ($resultsnb = $xwiki.xWiki.search("select count(doc) from XWikiDocument doc ${query}", $context.context).get(0)) #if ($resultsnb > $resultsPerPage) #set ($pagesnb = $resultsnb / $resultsPerPage) #foreach ($pagenb in [0..$pagesnb]) [$pagenb>$doc.fullName?page=$pagenb] #end #end #set ($list = $xwiki.searchDocuments($query, $resultsPerPage, $start)) #foreach ($item in $list) * $item #end #end #if ($request.page) #set ($desiredStart = $xwiki.parseInt($request.page)) #else #set ($desiredStart = 0) #end #paginedSearch("where 1=1" $desiredStart 5) -----------------------------------------------8<--------------------------- ---------------------------------------- 2007/10/3, goldring, richard &lt;richard.goldring(a)uk.thalesgroup.com&gt;om>: list numbers really tasks/issues. those that for e-mail it to Business _______________________________________________ devs mailing list devs(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/devs Thales UK Ltd (Wells) DISCLAIMER: The information contained in this e-mail is confidential. It may also be legally privileged. It is intended only for the stated addressee(s) and access to it by any other person is unauthorised. If you are not an addressee, you must not disclose, copy, circulate or in any other way use or rely on the information contained in this e-mail. Such unauthorised use may be unlawful. We may monitor all e-mail communications through our networks. If you have received this e-mail in error, please inform us immediately on +44 (0) 1749 672081 and delete it and all copies from your system. We accept no responsibility for changes to any e-mail which occur after it has been sent. Attachments to this e-mail may contain software viruses which could damage your system. We therefore recommend you virus-check all attachments before opening. A business of Thales UK Ltd. Registered Office: 2 Dashwood Lang Road, The Bourne Business Park, Addlestone, Weybridge, Surrey KT15 2NX Registered in England No. 868273