Wiki source code of Тестирование HQLQuery
Last modified by Eugen Colesnicov on 2010/05/11 00:41
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | 1 HQL Query tester | ||
| 2 | |||
| 3 | xwiki.searchDocuments | ||
| 4 | |||
| 5 | <form method="post"> <textarea name="searchDocumentsQuery" rows="4" style="width:90%;"> #if($request.searchDocumentsQuery)$request.searchDocumentsQuery#else where doc.author='XWiki.Admin' #end </textarea> <br/> <input type="submit"> </form> | ||
| 6 | |||
| 7 | #if ($request.searchDocumentsQuery) | ||
| 8 | Results | ||
| 9 | |||
| 10 | #set ($results = $xwiki.searchDocuments($request.searchDocumentsQuery.trim())) #foreach ($result in $results) * $result #end #end | ||
| 11 | |||
| 12 | xwiki.search (privileged API) | ||
| 13 | |||
| 14 | <form method="post"> <textarea name="searchQuery" rows="4" style="width:90%;"> #if($request.searchQuery) $request.searchQuery #else select doc.fullName, firstname.value, lastname.value from XWikiDocument doc, BaseObject obj, StringProperty firstname, StringProperty lastname where obj.className='XWiki.XWikiUsers' and obj.name=doc.fullName and obj.id=firstname.id.id and firstname.id.name='first_name' and lastname.id.name='last_name' and obj.id=lastname.id.id #end </textarea> <br/> <input type="submit"> </form> | ||
| 15 | |||
| 16 | #if ($request.searchQuery) | ||
| 17 | Results | ||
| 18 | |||
| 19 | #set ($results = $xwiki.search($request.searchQuery.trim())) {table} #foreach ($result in $results) #foreach ($item in $result) #if ($velocityCount > 1)|#end $item #end #end {table} #end |