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.


Warning: count(): Parameter must be an array or an object that implements Countable in /homepages/37/d447437781/htdocs/aemtuts/wp-includes/class-wp-comment-query.php on line 405

Leave a Reply