AEM6.3 How to use Query Debugger tool

Statement - How to use the Query Debugger tool
Solution -
Go to this path: http://localhost:4502/libs/cq/search/content/querydebug.html

This tool is used to perform search queries on JCR
For Example - Search all assets under /content/dam folder
Use the below query : type= dam:Asset
path=/content/dam

Similarly we can perform the below Search.

Builder API Queries
How many ACL are in effect under /content/dam
Use the below query : type= rep:ACL
path = /content/dam

As shown in the screenshot

How many web pages are there in the System
Use the below query type=cq: page
path=/content

How many components under the root node or specific path
Use the below query for specific path type=cq: component
path=/apps/we-retail-screens/components

Or

Use the below query for root path type=cq:component
path=/content

Some Different Types of cq types as follows and path can be anything based on the need you can choose the path

1. sling:OsgiConfig
2. cq:WidgetCollection
3. cq:Widget
4. cq:WorkflowData
5. oak:Unstructured
6. cq:ClientLibraryFolder
7. sling:Mapping
8. cq:Page
9. cq:PageContent
10. cq:WorkflowModel
11. cq:WorkflowLauncher
12. rep:Restrictions
13. nt:folder
14. cq:Payload
15. cq:TabPanel
16. rep:DenyACE
17. rep:GrantACE
18. cq:Panel
19. sling:OrderedFolder
20. rep:ACL
21. nt:unstructured
22. sling:Folder
23. cq:LiveSyncAction
24. cq:Tag
25. nt:file
26. cq:Dialog
27. granite:Task
28. dam:Asset
29. cq:WorkItem
30. cq:WorkflowNode
31. cq:Workflow
32. vlt:PackageDefinition
33. nt:resource
34. dam:AssetContent
35. cq:WorkflowTransition

How many tags defined
type=cq:Tag
path=/etc/tags

How many total users are defined in the AEM
type=rep:User
path=/home/users
How many (total) indexes have been defined
type=oak:QueryIndexDefinition

How many user groups are defined
type=rep:Grouppath=/home/groups

List all assets shot with a Canon camera:
path=/content/dam
nodename=metadata
property=tiff:Make
property.value=Canon

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

Search for all DAM assets in /content/dam which are JPG images that were added since March 10, 2018 and to to sort the results in the descending order, Execute the following query:
type=dam:Asset
path=/content/dam
property=jcr:content/metadata/dc:format
property.value=image/jpeg
daterange.property=jcr:content/jcr:lastModified
daterange.lowerBound=2018-03-10
orderby.sort=desc

Find jar files and order them, newest first
http://localhost:4502/bin/querybuilder.json?type=nt:file&nodename=*.jar&orderby=@jcr:content/jcr:lastModified&orderby.sort=desc

type=nt:file
nodename=*.jar
orderby=@jcr:content/jcr:lastModified
orderby.sort=desc

Find all pages and order them by last modified
http://localhost:4502/bin/querybuilder.json?type=cq:Page&orderby=@jcr:content/cq:lastModified

type=cq:Page
orderby=@jcr:content/cq:lastModified

Find all pages and order them by last modified, but descending
http://localhost:4502/bin/querybuilder.json?type=cq:Page&orderby=@jcr:content/cq:lastModified&orderby.sort=desc

type=cq:Page
orderby=@jcr:content/cq:lastModified
orderby.sort=desc

Fulltext search, ordered by score
http://localhost:4502/bin/querybuilder.json?fulltext=Management&orderby=@jcr:score&orderby.sort=desc

fulltext=Management
orderby=@jcr:score
orderby.sort=desc

Fulltext search for Women in the path :/content/screen

fulltext=women
orderby=@jcr:content
path=/content/screens

Search for pages tagged with a certain tag
http://localhost:4502/bin/querybuilder.json?type=cq:Page&tagid=marketing:interest/product&tagid.property=jcr:content/cq:tags
type=cq:Page
tagid=marketing:interest/product

tagid.property=jcr:content/cq:tags

Advantages of Query Builder:
Query Builder is easy to read and write
No need to hard code time range in it