Developer Tool

AEM Query & Report Builder.

Pick a report type, fill in path / template / resource type / properties, and get the query in four formats: QueryBuilder(predicate, JSON URL & Java), JCR-SQL2, and XPath. Runs entirely in your browser. How to use

1. Choose a report

Find pages under a path. Add filters below to narrow it down.

Report nameused for file names & the Java method

2. Where to search

Content pathYour project root, e.g. /content/wkndNode type

3. What to match (leave blank to skip)

Templatecq:template pathComponent (resource type)sling:resourceTypeTagcq:tags

Property filters

None — add one to filter by a specific property/value.

QueryBuilder predicate

path=/content/wknd
type=cq:Page
orderby=@jcr:content/cq:lastModified
orderby.sort=desc
p.limit=100
p.guessTotal=true
p.properties=jcr:path jcr:content/jcr:title jcr:content/cq:template

querybuilder.json URL

/bin/querybuilder.json?path=%2Fcontent%2Fwknd&type=cq%3APage&orderby=%40jcr%3Acontent%2Fcq%3AlastModified&orderby.sort=desc&p.limit=100&p.guessTotal=true&p.properties=jcr%3Apath%20jcr%3Acontent%2Fjcr%3Atitle%20jcr%3Acontent%2Fcq%3Atemplate

Examples use the WKND project — swap wknd for your app name. QueryBuilder is the source of truth; SQL2/XPath are best-effort equivalents and operation names vary slightly by AEM version. Runs entirely in your browser.