Failed to execute template. Cause: [Access denied when checking [script] access to [xwiki:Collaboratory.UX.HbpSkin.WebHome] for user [xwiki:XWiki.Admin]]. Click on this message for details.

Query - HBP Wiki

IAM21 instance, do not create collab nor modify a team, your changes will be lost


Wiki source code of Query

Last modified by hbpadmin on 2022/08/25 01:29

Show last authors
1 {{velocity}}
2 #if($hasProgramming)
3 #set($sqlTools = $xwiki.parseGroovyFromPage('SQLTools.SQLToolsGroovy'))
4 = Query =
5 $sqlTools.getForm($request, $doc, true, true)
6 #if($request.query)
7 #set($connection = $sqlTools.getConnectionFromRequest($request))
8 #set($results = $sqlTools.getResults($connection, $request.query, true))
9 = Results =
10 $results
11 #end
12 #else
13 {{error}}Sorry, you need the programming rights to use this tool{{/error}}
14 #end
15 {{/velocity}}