Query Language Specification
| Query | Current Hibernate method | Current QueryPlugin method (with unimplemented child axis support) | Method 1 | Method 2 | Method 3 | Method 4 |
| Query listing all documents | empty query | /*/* | empty query | empty query | empty query | empty query |
| Query listing all documents create after a date | where [doc.]creationDate > '2008-01-01' | /*/*[@creationDate > '2008-01-01'] | where [doc.]creationDate > '2008-01-01' | where [doc.]creationDate > '2008-01-01' | where [doc.]creationDate > '2008-01-01' | where [doc.]creationDate > '2008-01-01' |
| Query listing all documents last updated by a user | where [doc.]author = 'XWiki.LudovicDubost' | /*/*[@author = 'XWiki.LudovicDubost'] | where [doc.]author = 'XWiki.LudovicDubost' | where [doc.]author = 'XWiki.LudovicDubost' | where [doc.]author = 'XWiki.LudovicDubost' | where [doc.]author = 'XWiki.LudovicDubost' |
| Query listing all documents with a class | , BaseObject as obj where doc.fullName = obj.name and obj.className = 'XWiki.XWikiUsers' | /*/*[obj/XWiki/XWikiUsers] | from XWiki.XWikiUsers | where [doc.]XWiki.XWikiUsers | where [doc.]class = 'XWiki.XWikiUsers' | , XWiki.XWikiUsers as user where [doc.]id = user.docId |
| Query on document with a class with a filter | , BaseObject as obj, StringProperty as prop where doc.fullName = obj.name and obj.className = 'XWiki.XWikiUsers' and obj.id=prop.id.id and prop.id.name='email' and prop.value like '%xwiki.com' and [doc.]author ='XWiki.LudovicDubost' | /*/*[@author='XWiki.LudovicDubost' and obj/XWiki/XWikiUsers/@xp:email like '%xwiki.com'] | from XWiki.XWikiUsers as user where user.email like '%xwiki.com' and [doc.]author='XWiki.LudovicDubost' | where [[doc.]XWiki.XWikiUsers and] [doc.]XWiki.XWikiUsers.email like '%xwiki.com' and [doc.]author = 'XWiki.LudovicDubost' | where [[doc.]class = 'XWiki.XWikiUsers' and] [doc.]XWiki.XWikiUsers.email like '%xwiki.com' and [doc.]author = 'XWiki.LudovicDubost' | , XWiki.XWikiUsers as user where [doc.]id = user.docId and user.email like '%.xwiki.com' and [doc.]author = 'XWiki.LudovicDubost' |
| Query with 2 classes | , BaseObject as obj, StringProperty as prop, BaseObject as obj2, LargeStringProperty as contentprop where doc.fullName = obj.name and obj.className = 'XWiki.XWikiUsers' and obj.id=prop.id.id and prop.id.name='email' and prop.value like '%xwiki.com' and doc.fullName=obj2.name and obj2.className='XWiki.ArticleClass' and obj2.id=contentprop.id.id and contentprop.id.name='content' and contentprop.value like '%ludovic%' | /*/*[obj/XWiki/XWikiUsers/@xp:email like '%xwiki.com' and obj/XWiki/ArticleClass/@xp:content like '%ludovic%'] | from XWiki.XWikiUsers as user, XWiki.ArticleClass as article where user.email like '%xwiki.com' and article.content like '%ludovic%' | where [[doc.]XWiki.XWikiUsers and] [[doc.]XWiki.ArticleClass and] [doc.]XWiki.XWikiUsers.email like '%xwiki.com' and [doc.]XWiki.ArticleClass like '%ludovic%' | where [[doc.]class = 'XWiki.XWikiUsers' and] [[doc.]class = 'XWiki.ArticleClass' and] [doc.]XWiki.XWikiUsers.email like '%xwiki.com' and [doc.]XWiki.ArticleClass like '%ludovic%' | ,XWiki.XWikiUsers as user, XWiki.ArticleClass as article where [doc.]id = user.docId and [doc.]id=article.docId and user.email like '%.xwiki.com' and article.content like '%ludovic%' |
Version 2.2 last modified by amelentev on 15/05/2008 at 16:51
Document data
Attachments:
No attachments for this document
Comments: 0