[xwiki-users] getting documents "I've been involved in" - xwiki-users@xwiki.org - lists.xwiki.org

List overview All Threads
Download

[xwiki-users] getting documents "I've been involved in"

Re: [xwiki-users] Idea for...

[xwiki-users] Project students

Paul Libbrecht

30 Jan 2008 30 Jan '08

1:11 a.m.

hello, what would be the query to obtain all the documents that a user has been editing, at any revision? thanks paul

Attachments:

smime.p7s (application/pkcs7-signature — 2.2 KB)

Reply

Show replies by date

[Ricardo Rodriguez] Your EPEC Network ICT Team

30 Jan 30 Jan

1:23 a.m.

Paul Libbrecht wrote:

hello, what would be the query to obtain all the documents that a user has been editing, at any revision? thanks paul

Hi Paul Could the code in My Recent Modifications panel help you? #set($recentDocs = $xwiki.searchDocuments("where 1=1 and doc.author='$context.user' order by doc.date desc", 5, 0)) #if($recentDocs.size() > 0 || $showEmptyPanels) #panelheader($msg.get("My Recent Modifications")) #set($first = true) #foreach($docname in $recentDocs) #set($rdoc = $xwiki.getDocument($docname).getTranslatedDocument()) #if($first == true) #set($first = false) #else <span class="pitemseparator"> | </span> #end <span class="panelitem"><a href="$rdoc.getURL("view")">$rdoc.displayTitle</a></span> #end #panelfooter() #end HTH, Ricardo -- Ricardo Rodríguez Your EPEC Network ICT Team

Reply

Sergiu Dumitriu

31 Jan 31 Jan

6:48 p.m.

Hi, The code from the "My recent modifications" panel doesn't help much, as it lists only documents which have the user as the most recent author, and not those that were sometime edited by the user. A proper query would be: select distinct doc.fullName from XWikiDocument doc, XWikiRCSNodeInfo ni where ni.id.docId = doc.id and ni.author = 'the user name' This query lists only the name of the documents, not the versions. If you also need the version numbers, use this: select doc.fullName, ni.id.version1, ni.id.version2 from XWikiDocument doc, XWikiRCSNodeInfo ni where ni.id.docId = doc.id and ni.author = 'the user name' These queries need programming rights, so you will have to write a java plugin that executes them and use the plugin from velocity, or put them in a page that will always have programming rights. Sergiu [Ricardo Rodriguez] Your EPEC Network ICT Team wrote:

Paul Libbrecht wrote:

hello, what would be the query to obtain all the documents that a user has been editing, at any revision? thanks paul

Hi Paul Could the code in My Recent Modifications panel help you? #set($recentDocs = $xwiki.searchDocuments("where 1=1 and doc.author='$context.user' order by doc.date desc", 5, 0)) #if($recentDocs.size() > 0 || $showEmptyPanels) #panelheader($msg.get("My Recent Modifications")) #set($first = true) #foreach($docname in $recentDocs) #set($rdoc = $xwiki.getDocument($docname).getTranslatedDocument()) #if($first == true) #set($first = false) #else <span class="pitemseparator"> | </span> #end <span class="panelitem"><a href="$rdoc.getURL("view")">$rdoc.displayTitle</a></span> #end #panelfooter() #end HTH, Ricardo

Reply

Ludovic Dubost

1 Feb 1 Feb

4:41 p.m.

Note also that it requires XWiki 1.2 Ludovic Sergiu Dumitriu wrote:

Hi, The code from the "My recent modifications" panel doesn't help much, as it lists only documents which have the user as the most recent author, and not those that were sometime edited by the user. A proper query would be: select distinct doc.fullName from XWikiDocument doc, XWikiRCSNodeInfo ni where ni.id.docId = doc.id and ni.author = 'the user name' This query lists only the name of the documents, not the versions. If you also need the version numbers, use this: select doc.fullName, ni.id.version1, ni.id.version2 from XWikiDocument doc, XWikiRCSNodeInfo ni where ni.id.docId = doc.id and ni.author = 'the user name' These queries need programming rights, so you will have to write a java plugin that executes them and use the plugin from velocity, or put them in a page that will always have programming rights. Sergiu [Ricardo Rodriguez] Your EPEC Network ICT Team wrote:

Paul Libbrecht wrote:

hello, what would be the query to obtain all the documents that a user has been editing, at any revision? thanks paul

Hi Paul Could the code in My Recent Modifications panel help you? #set($recentDocs = $xwiki.searchDocuments("where 1=1 and doc.author='$context.user' order by doc.date desc", 5, 0)) #if($recentDocs.size() > 0 || $showEmptyPanels) #panelheader($msg.get("My Recent Modifications")) #set($first = true) #foreach($docname in $recentDocs) #set($rdoc = $xwiki.getDocument($docname).getTranslatedDocument()) #if($first == true) #set($first = false) #else <span class="pitemseparator"> | </span> #end <span class="panelitem"><a href="$rdoc.getURL("view")">$rdoc.displayTitle</a></span> #end #panelfooter() #end HTH, Ricardo

_______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

-- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost

Reply

6104

days inactive

6106

days old

xwiki-users@xwiki.org

Manage subscription

3 comments

4 participants

tags (0)

participants (4)

[Ricardo Rodriguez] Your EPEC Network ICT Team
Ludovic Dubost
Paul Libbrecht
Sergiu Dumitriu