Crx/de query | Adobe Higher Education
Skip to main content
G
giuseppes244301
Level 2
May 4, 2018
Répondu

Crx/de query

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.

Ce sujet a été fermé aux réponses.
Meilleure réponse par arunpatidar

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

7 commentaires

shridhar_sahu
shridhar_sahu
Level 3
May 4, 2018

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

    G
    giuseppes244301Auteur
    Level 2
    May 4, 2018

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

    shridhar_sahu
    shridhar_sahu
    Level 3
    May 4, 2018

    yes directly from crxde -> tools -> query

    write query and then execute

    G
    giuseppes244301Auteur
    Level 2
    May 4, 2018

    Done, it shows only the path

    smacdonald2008
    smacdonald2008
    Level 10
    May 4, 2018

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

    arunpatidar
    Community Advisor
    arunpatidarCommunity AdvisorRéponse
    Community Advisor
    May 5, 2018

    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
      giuseppes244301Auteur
      Level 2
      May 7, 2018

      Thank you so much

      Conditions d'utilisationAccessibility statement

      Loading footer...