adoro wrote:
Hi all,
Can someone help me? I need urgent two HQL queries:
1. Query for all "wanted pages" - pages that have been linked to, but are not yet written - new pages (links with the question mark next to them);
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.
2. The version number of the document I restored/rolled back to.
That's a bit hard... Rollback is not an actual rollback, like pointing back to an older version, but the old version is loaded from the history and saved as a new version. You could parse the version comment, which looks like: "Rollback to version 2.1", and extract the version from there. -- Sergiu Dumitriu http://purl.org/net/sergiu/