Hello,
is there a way to create a query (SQL, SQL2 or Xpath) in order to show the path and one property of the node in crx/de ?
like
select jcr:title from nt:base
where jcr:path LIKE '/content/.....'
and show in crx/de 2 columns Path and jcr:title.
Thank you so much.
You can achieve this by Query debugger Tool as suggested by Scott
http://localhost:4502/libs/cq/search/content/querydebug.html
Query
type=nt:base
path:/content/AEM63App/en
property:jcr:title
property.operation : exists
p.hits=selective
p.nodedepth
p.properties=jcr:path jcr:title
p.limit : 21
you can modify above query based on your search criteria.
when you execute this you will be getting an option to get Json query via JSON QueryBuilder Link, when you hit this link you'll get the results like below:
"success":true,
"results":21,
"total":21,
"more":false,
"offset":0,
"jcr:path":"/content/AEM63App/en/travel/jcr:content",
"jcr:title":"Travel"
},
"jcr:path":"/content/AEM63App/en/community/jcr:content",
"jcr:title":"Our Community"
},
...
]
you can parse this Json and use wherever you want.
hope this will help.
Thanks
Arun
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.