Crx/de query

[giuseppes244301]

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.

[shridhar_sahu]

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

[giuseppes244301]

jcr-sql queries and execute direclty in crx/de ?

[shridhar_sahu]

yes directly from crxde -> tools -> query

write query and then execute

[giuseppes244301]

Done, it shows only the path

[smacdonald2008]

See this blog here -- CQ-OPS - How to Use CQ's Query Debugger Tool

[arunpatidar · Accepted solution]

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

[giuseppes244301]

Thank you so much