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.
Solved! Go to Solution.
Views
Replies
Total Likes
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
Hi,
The best practice is to write jcr-sql queries and execute it.
So instead of generating, write jcr-sql query and you can always check the output by clicking on execute instead of generate.
Follow to below link to learn jcr query:
Chapter 10. Querying and Searching using JCR
Thanks,
Shridhar Sahu
jcr-sql queries and execute direclty in crx/de ?
Views
Replies
Total Likes
yes directly from crxde -> tools -> query
write query and then execute
Views
Replies
Total Likes
Done, it shows only the path
Views
Replies
Total Likes
See this blog here -- CQ-OPS - How to Use CQ's Query Debugger Tool
Views
Replies
Total Likes
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
Thank you so much
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies