AEM Toolbox

The Toolbox for AEM contains currently one tool only, a client for AEM's Query Builder.

It can be deployed as self-contained application package – no need to install anything in AEM itself.

Sources for application and deployment packages can be found on GitHub.

Query Builder Client

The Query Builder Client is handy for doing ad hoc queries against AEM. Queries are executed over HTTP using the Query Builder (JSON) Servlet at /bin/querybuilder.json.

Where Query Builder Debugger (/libs/cq/search/content/querydebug.html) allows testing and playing around with queries, the Query Builder Client allows playing around with the result, namely formatting and filtering of hits.

Template Editor

Hits are formatted by the given Handlebars template, {{this}} in its simplest form.

Filter Editor

The filter is a simple Java String contains or matches function.

Copy hits

Copy the formatted and filtered hits to clipboard.


Examples for AEM 6.3 with sample content installed

Find all users with a given name and order by family name

Query

path=/home/users
type=rep:User
property=givenName
property.depth=3
property.operation=exists
orderby=@profile/familyName
p.limit=-1
p.hits=selective
p.nodedepth=5
p.properties=rep:authorizableId profile/email profile/familyName profile/givenName
Template

{{rep:authorizableId}};{{profile/email}};{{profile/familyName}},{{profile/givenName}}
Hits

varmstrong;virginia.l.armstrong@we-retail.net;Armstrong,Virginia
cavery;cavery@we-retail.net;Avery,Carlene
imccoy;iris.r.mccoy@we-retail.net;Mccoy,Iris
willie.melton@dodgit.com;willie.melton@dodgit.com;Melton,Willie
zachary.mitchell@spambob.com;zachary.mitchell@spambob.com;Mitchell,Zachary
olive.pixley@spambob.com;olive.pixley@spambob.com;Pixley,Olive
ksaner;kerri.saner@we-retail.net;Saner,Kerri

Tagged with: