Code source wiki de MeetingParticipantSuggest

Modifié par Vincent Massol le 2011/08/12 21:26

Afficher les derniers auteurs
1 $response.setContentType("text/xml")
2 <?xml version="1.0" encoding="UTF-8"?>
3 #set($input = "$!request.input")
4 #set($input = $input.toLowerCase())
5 #set($i = $input.lastIndexOf(","))
6 #set($i = $i + 1)
7 #set($input = $input.substring($i))
8 #set($meeting = "$!request.meeting")
9 #set($query = ", BaseObject as obj, StringProperty as firstName, StringProperty as lastName where obj.name=doc.fullName and obj.className='XWiki.XWikiUsers' and firstName.id.id=obj.id and lastName.id.id=obj.id and firstName.id.name='first_name' and lastName.id.name='last_name' and (lower(firstName.value) like '${input}%' or lower(lastName.value) like '${input}%' or lower(doc.name) like '${input}%') and not exists(select p.name from BaseObject as p, StringProperty as m where p.className='MMCode.MeetingParticipantClass' and p.name='${meeting}' and m.id.id=p.id and m.id.name='username' and m.value=doc.fullName)")
10 <results>
11 #foreach($matched in $xwiki.searchDocuments($query))
12 <rs id="$matched" info="$matched">$xwiki.getUserName($matched, false)</rs>
13 #end
14 </results>