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

2008-11-14 Thread adoro
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 =

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

2008-11-14 Thread Vincent Massol
Hi Adoro, One you have something fully working, would be nice if you could contribute this back on code.xwiki.org as a code snippet. Thanks -Vincent On Nov 14, 2008, at 4:58 PM, adoro wrote: Hi Sergiu, thank you so much for your help, the wanted pages query works fine if I use it for

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

2008-11-13 Thread adoro
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); 2. The version number of the document I restored/rolled back to. Thanks in advance,