Code source wiki de Query Generator

Montrer les numéros de lignes
{{velocity}}
{{html}}
<form action ="">
Generate form for class: <select name="classname">
#if($request.classname)
#set($classname = $request.classname)
#else
#set($classname = "XWiki.XWikiUsers")
#end
#set($classes = $xwiki.classList)
#foreach($classn in $classes)
<option value="${classn}" #if($classname==$classn) selected #end>$classn</option>
#end
</select>
<input type="submit" value="Go" />
</form>
{{/html}}



## Code
#set($query = $xwiki.createQueryFromRequest($classname))
#set($class = $xwiki.getDocument($classname).xWikiClass)

#set($displayfields = $query.displayProperties)
#set($fields = $xwiki.getDocument($classname).xWikiClass.propertyNames)
#if($displayfields.size()==0)
#set($displayfields = "")
#end
#set($mydoc = $xwiki.getDocument("Sandbox.Sandbox"))
#set($ok = $mydoc.newObject($classname))
#set($ok = $mydoc.use($classname))
{{html clean=false}}
<form action="" method="get">
<input type="hidden" name="query" value="1" />
<input type="hidden" name="classname" value="$classname" />
<table border="0">
#set($even = true)
#foreach($field in $fields)
#if($even==true)
<tr>
#end
<td><b>$mydoc.displayPrettyName($field)</b></td><td>$xwiki.displaySearch($field, $classname, $query)</td>
#if($even==false)
</tr>
#end
 #set($even = !$even)
#end
#if($even==false)
</tr>
#end
<tr><td><b>Columns</b></td><td>$xwiki.displaySearchColumns($classname, $query)</td>
<td><b>Order by</b></td><td>$xwiki.displaySearchOrder($classname, $query)</td></tr>
</table>
<input type="submit" value="Go" />
</form>

#if($request.query)
#if($request.order)
#set($order=$request.order)
#end

#set($qplugin = $xwiki.parseGroovyFromPage("Macros.QueryGeneratorGroovy").getQueryPlugin($context))
#set($xwlquery = $qplugin.makeQuery($query))
#set($columns = [])
#foreach($field in $displayfields)
#set($ok = $columns.add($field.replaceAll("${classname}_","")))
#end
#set($columns = $stringtool.join($columns,","))
<ul>
<li><b>Query (xwql):</b>  $xwlquery</li>
<li><b>Columns:</b>$columns</li>
<li><b>Macro:</b>{{query query="$xwlquery" class="$classname" columns="$columns" headers="1" links="0" actions="1" /}}
</li>
<ul>
{{/html}}

{{query query="$xwlquery" class="$classname" columns="$columns" headers="1" links="0" actions="1" /}}
#end
{{/velocity}}
Code source wiki de Query Generator

Accès Rapide

Mes dernières modifications
