Re: [xwiki-users] Please, badly need help with HQL...

Hi Sergiu, thank you so much for your help, the "wanted pages" query works fine if I use it for certain spaces: #set($sql= "select link.fullName, link.link.id from XWikiLink link where link.fullName like 'MySpace.%' and not exists (select doc.fullName from XWikiDocument doc where doc.fullName = link.id.link) order by 1") #set($results= $xwiki.search($sql)) #if ($results.size() == 0) #warning('Es gibt keine gewünschte Seiten') #else {table} Space|Document|Link #foreach ($row in $results) #foreach ($col in $row) #if ($velocityCount==1) #set($docFullName=$col) #elseif ($velocityCount==2) #set($emptyLink=$col) #set($el=$emptyLink.getLink()) #set($spaceName=$xwiki.getDocument($docFullName).space) #end #end $spaceName|[$docFullName]|$el #end {table} #end Best Regards, Alla Sergiu Dumitriu-2 wrote: > > > This should work: > > #set($query = "select link.id.link from XWikiLink link where not > exists > (from XWikiDocument doc where doc.fullName = link.id.link)") > #foreach($item in $xwiki.search($query)) > * $item > #end > > Note that several bad entries are placed there because the link > detection process does not pre-run velocity, so lots of entries > actually > point to velocity variables or javascript code. Definitely the > backlinks > need to be revised in the new rendering. > > Sergiu Dumitriu > http://purl.org/net/sergiu/