Sample Queries for XWQL
Last modified by Thomas Mortagne on 2013/09/19 15:58
Get pages withing a space
$xwiki.queryManager.xwql("where doc.space='Main'").execute()
Returns 92 items
Get pages restricted by date
$xwiki.queryManager.xwql("where doc.space='Main' and doc.date>'2009-01-01'").execute()
Returns 82 items
Get pages containing a class
$xwiki.queryManager.xwql("from doc.object(XWiki.XWikiUsers) as user where doc.space='XWiki'").execute()
Returns 2400 items
Get pages containing a class and a restriction on a field
$xwiki.queryManager.xwql("where doc.object(XWiki.XWikiUsers).email like '%xwiki.com' and doc.space='XWiki'").execute()
Returns 20 items
$xwiki.queryManager.xwql("from doc.object(XWiki.XWikiUsers) as user where user.email like '%xwiki.com'").execute()
Returns 20 items
Get pages containing a class and a restriction on a multiple list field
$xwiki.queryManager.xwql("from doc.object(XWiki.XWikiUsers) as user, doc.object(XWiki.TagClass) as tag where 'test' member of tag.tags").execute()
Returns 0 items