Re: [xwiki-devs] How to write HQL queries for recently modified pages under a specific space

On Thu, Aug 11, 2011 at 1:03 AM, Sergiu Dumitriu<sergiu(a)xwiki.com> wrote: I have tried both, but all failed, the error infomation is bellow: Failed to execute the [velocity] macroorg.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate Velocity Macro for content [#set($media = "$!request.media") #set($nb = "$!request.nb") #if($nb != '') #set($nb = $util.parseInt($nb) + 1) #else #set($nb = 5) #end #if ($media == 'json') #set($discard = $response.setContentType("application/json")) #set ($recentlyModifiedPage = $xwiki.searchDocuments('where where doc.space=''Main'' order by doc.date desc order by doc.date desc', $nb, 0))

#set($size = $recentlyModifiedPage.size()) [ #foreach ($docname in $recentlyModifiedPage) #if ($xwiki.hasAccessLevel('view', $xcontext.getUser(), $docname)) #set ($rdoc = $xwiki.getDocument($docname)) #set($name = $rdoc.getName()) #set($fullname = "$rdoc.getWiki():$rdoc.getSpace().$rdoc.getName()") {"info":"${escapetool.javascript($rdoc.fullName)}", "path":"${escapetool.javascript($fullname)}", "name":"$name", "type":"wikipage"} #if($velocityCount< $size) , #end #end #end