How to query AEM’s resources through SQL syntax

Do you want to find some AEM resources within a workflow ? Do you want to query resources like a simple SQL DB query ? This is possible via JCR SQL through sling API 🙂 There is two others solutions : JCR XPATH and JCR SQL 2.

The following example find nodes with the property “sling:vanityPath” within the path “/content/myapp/” :

Please find here a query Cheat Sheet to help you with the syntax.


Leave a Reply