Query Builder samples

AEM comes with a Query Debugger tool at:

/libs/cq/search/content/querydebug.html

You can execute search queries on the JCR (Java Content Repository) using this tool.  For example, to search for all DAM assets in /content/dam/geometrixx, execute the following query:

type=dam:Asset
path=/content/dam/geometrixx

See screenshot below:

Running this search query should produce a result such as follows:

You can execute more complicated search queries as well.  For example, to search for all DAM assets in /content/dam/geometrixx with the string “.png” in the node name and to to sort the results in the descending order of when the node was last modified, execute the following query:

type=dam:Asset
path=/content/dam/geometrixx
nodename=*.png
orderby=@jcr:content/jcr:lastModified
orderby.sort=desc

More information here.  Excellent blog entry by Thomas Joseph on Oak indexes here.

Other examples:

How many audit events have accumulated:

type=cq:AuditEvent
path=/var/audit

How many unique users have logged in to AEM in the past 12 hours?

A user who has logged in from three different IP addresses (home office, work, mobile phone) will be counted three times.

type=rep:Token
path=/home/users

How many web pages are in the AEM system?

type=cq:Page
path=/content

How many tags have been defined?

type=cq:Tag
path=/etc/tags

How many total users are defined in the AEM system?

type=rep:User
path=/home/users

How many user groups are defined?

type=rep:Group
path=/home/groups

How many Client Libraries?

type=type=cq:ClientLibraryFolder
path=/etc

Read More