AEM6.3 How to use SQL2 & Xpath Query Tool

Statement - How to use SQL2 & Xpath Query Tool in AEM
Environment - AEM 6.3

Solution -
Go to this path http://localhost:4502/crx/explorer/ui/search.jsp?Path=&Query= 

User can enter the SQL query or Xpath Query for the search Xpath Query: to find a node of a given type
1. //element(*, dam:Asset)



SQL Query: To find a node of a given type

2. select * from [dam:Asset] as cm


Sample Queries:
1. Find all the string contains “Men” under /content

XPath:
/jcr:root/content//element(*)[jcr:contains(@*, 'men’)]

SQL:
SELECT * from [nt:base] AS t
where ISDESCENDANTNODE('/content') and
contains(t.*, ‘men’)

Query Builder API:
path=/content
fulltext=men

2. Find all nodes under /content created in the past month

XPath:
/jcr:root/content//*
[
((@jcr:created > xs:dateTime('2018-04-22T15:23:57.313Z')
and @jcr:created < xs:dateTime('2018-05-22T15:23:57.313Z')))
]

SQL:
select * from [nt:base] as a
where [jcr:created] > cast('2018-05-22T07:24:50.233Z' as date) and
[jcr:created] < cast('2018-05-22T07:24:50.233Z' as date) and
isdescendantnode(a, '/content')

Query Builder:
path=/content
1_relativedaterange.property=jcr:created
1__relativedaterange.lowerBound=-1M
1_relativedaterange.upperBound=0