Code source wiki de MeetingParticipantSuggest

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

version	line-number	content
1.1	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>

Divers