Wiki source code of Query Generator

Hide line numbers
 1: {{velocity}}
 2: {{html}}
 3: <form action ="">
 4: Generate form for class: <select name="classname">
 5: #if($request.classname)
 6: #set($classname = $request.classname)
 7: #else
 8: #set($classname = "XWiki.XWikiUsers")
 9: #end
10: #set($classes = $xwiki.classList)
11: #foreach($classn in $classes)
12: <option value="${classn}" #if($classname==$classn) selected #end>$classn</option>
13: #end
14: </select>
15: <input type="submit" value="Go" />
16: </form>
17: {{/html}}
18: 
19: 
20: 
21: ## Code
22: #set($query = $xwiki.createQueryFromRequest($classname))
23: #set($class = $xwiki.getDocument($classname).xWikiClass)
24: 
25: #set($displayfields = $query.displayProperties)
26: #set($fields = $xwiki.getDocument($classname).xWikiClass.propertyNames)
27: #if($displayfields.size()==0)
28: #set($displayfields = "")
29: #end
30: #set($mydoc = $xwiki.getDocument("Sandbox.Sandbox"))
31: #set($ok = $mydoc.newObject($classname))
32: #set($ok = $mydoc.use($classname))
33: {{html clean=false}}
34: <form action="" method="get">
35: <input type="hidden" name="query" value="1" />
36: <input type="hidden" name="classname" value="$classname" />
37: <table border="0">
38: #set($even = true)
39: #foreach($field in $fields)
40: #if($even==true)
41: <tr>
42: #end
43: <td><b>$mydoc.displayPrettyName($field)</b></td><td>$xwiki.displaySearch($field, $classname, $query)</td>
44: #if($even==false)
45: </tr>
46: #end
47:  #set($even = !$even)
48: #end
49: #if($even==false)
50: </tr>
51: #end
52: <tr><td><b>Columns</b></td><td>$xwiki.displaySearchColumns($classname, $query)</td>
53: <td><b>Order by</b></td><td>$xwiki.displaySearchOrder($classname, $query)</td></tr>
54: </table>
55: <input type="submit" value="Go" />
56: </form>
57: 
58: #if($request.query)
59: #if($request.order)
60: #set($order=$request.order)
61: #end
62: 
63: #set($qplugin = $xwiki.parseGroovyFromPage("Macros.QueryGeneratorGroovy").getQueryPlugin($context))
64: #set($xwlquery = $qplugin.makeQuery($query))
65: #set($columns = [])
66: #foreach($field in $displayfields)
67: #set($ok = $columns.add($field.replaceAll("${classname}_","")))
68: #end
69: #set($columns = $stringtool.join($columns,","))
70: <ul>
71: <li><b>Query (xwql):</b>  $xwlquery</li>
72: <li><b>Columns:</b>$columns</li>
73: <li><b>Macro:</b>{{query query="$xwlquery" class="$classname" columns="$columns" headers="1" links="0" actions="1" /}}
74: </li>
75: <ul>
76: {{/html}}
77: 
78: {{query query="$xwlquery" class="$classname" columns="$columns" headers="1" links="0" actions="1" /}}
79: #end
80: {{/velocity}}
Wiki source code of Query Generator

Quick Links

My Recent Modifications
