Query debugger interface in AEM

With AEM, one gets to store and manage huge amount of content. As such you will definitely come across a scenario when you have to look through these huge amount of content in order to filter out some pages which satisfy some pre-defined condition like - pages with a specific property. AEM provides you with a query builder interface, which lets you do the same. With this blog, I am going to give some overview on this and some useful query commands that some might need to get on with their daily tasks.

We can access the querybuilder debugger interface provided by AEM with the below url:

http://localhost:4502/libs/cq/search/content/querydebug.html

It will open up a screen like below: 

This is where you can run your query. So to get you started, i am going to list a few common predicates that you can use to run queries.

• path - specifies the path under which you want to run a query
• type - helps you to specify the type of the specific nodes you want to target or filter out.
• property - look for a specific property associated with the target resource
• group - merge a set of conditions together. You can also specify if all the conditions grouped together should be satisfied or not.
• daterange - used for filtering out the pages using the date properties associated with the resource.

Example 1: filter out some pages under a given path which have a specific property

the command that you could use for the above scenario will look something like this - 

Example 2 : check if a property exists under multiple paths

Example 3 : Filter out pages under a given path which were modified in between some pre-defined dates. For this you could use the query as given below.

Similarly, you could get the content that satisfies some custom conditions using the query debugger interface. There are other ways to run queries in AEM too, but will discuss those in some other blog. But for now, I hope this short and brief overview helps you in doing some of your daily tasks.

You can get the complete list of predicates that you could play around with in the link below:
Query Builder Predicate Reference | Adobe Experience Manager