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 all instances of a "Teaser" paragraph |
select * from nt:base where mgnl:template = 'stkTeaser' |
//*[@mgnl:template = 'stkTeaser'] |
Get listing of available paragraph types |
select * from nt:base where jcr:path like '/modules/%/paragraphs/%' and type is not null |
/jcr:root/modules[1]//*/paragraphs[1]//*[@type] |
|
|
|
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.