Level 2

Solved

Crx/de query

7 replies
10381 views
Translate

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

arunpatidarAccepted solution

New Participant

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,

"hits":[

{

"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

Arun Patidar

G

giuseppes244301Author