On Oct 3, 2007, at 3:53 PM, goldring, richard wrote:
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
Yes, agreed. We know we need this. What we need is contributors willing to help at this point. If users were contributing back what they succeed in doing (after asking on the list) we would have nice tutorials covering everything :) Are you interested in contributing what you've succeeded in doing? Xwiki.org is a wiki so you can easily add stuff on there. I think the dev guide would be a logical place for putting this. WDYT? Thanks -Vincent
-----Original Message----- From: [email protected] [mailto:[email protected]]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 <[email protected]>:
Anyone?
Hi all,
Does anyone know how to generate a list of links to wiki pages that meet a set of defined features i.e. filter and sort (features defined on the objects or tags on those pages)? Perhaps like the Google search, list the first 20 or 30 pages and have a next/previous, 1, 2, 3, etc buttons to list the next selections of page links (to cope with the display of large numbers of page links).
If anyones got any code snipits to get me started then that would be really useful - thanks.
The idea is perhaps to explore how to use XWiki to semi automatically generate pages to record tasks or issues, and then to list those pages (tasks/issues) according to say the status or owners of those tasks/issues. For tasks I'm thinking XWiki might be used to help guide users through business processes and semi-automatically document they have followed those processes (for CMMI) so they can be simply audited. Documents generated through users following the tasks/processes can then be generated from templates and stored within the wiki. If anyone else has any ideas/ code that could help perhaps realise this then let me know!
Regards,
Richard Goldring