This is a collection of mini-recipes for doing JCR queries. Please add your own!
|
SQL |
XPath (deprecated in JCR 2.0) |
---|---|---|
Get all pages |
select * from mgnl:content |
//element(*, mgnl:content) |
Get all pages with "News" in the title |
select * from mgnl:content where title like '%News%' |
//element(*, mgnl:content)jcr:like(@title, '%News%') |
Get all pages where the title exactly matches "News" (case sensitive) |
select * from mgnl:content where title like 'News' |
//element(*, mgnl:content)@title = 'News' |
Get all STK pages that have a header image |
select * from mgnl:content where image is not null |
//element(*, mgnl:content)@image |
|
|
|
Get user with email 'eric@example.com' |
select * from mgnl:user where email = 'eric@example.com' |
//element(*, mgnl:user)@email = 'eric@example.com' |
Note: you can use the translator to convert from one format to another.