Skip to main content
GK-007
GK-007
Level 9
December 9, 2016
Solved

Is there way to know nodes without jcr:content node?

Hi All,

Is there any way/tool to know the JCR nodes without jcr:content?

Please help me!!!

Thanks,

Kishore

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
kautuk_sahni
kautuk_sahniAccepted solution
Adobe Employee
December 12, 2016

Hi 

Please have a look at these posts:- 

Link:-http://help-forums.adobe.com/content/adobeforums/en/experience-manager-forum/adobe-experience-manager.topic.html/forum__aswh-hello_can_someon.html

// How to find nodes without specific child node? How can I find nodes without specific child node (e.g. jcr:content)?

 

Link:- http://stackoverflow.com/questions/25019693/cq-5-query-builder-to-get-list-of-pages-without-jcrcontent-node

// to get list of pages without jcr:content node

 

I hope this would help you.

~kautuk

Kautuk Sahni
View in thread

17 replies

Show previous replies
arunpatidar
Community Advisor
arunpatidarCommunity Advisor
Community Advisor
June 7, 2018

HI,

I above query child is a custom predicate , you have to create that before using. same is mentioned in Link also.

but If you want to check specific node with name you can use nodename like below:

path=/content/dam

type=dam:Assest

nodename=jcr:content

p.limit=-1

Translate
Arun Patidar
    velpa
    Level 2
    June 8, 2018

    Hi ,

            I Had tried with this Query as well.

    type=dam:Assest

    path=/content/dam

    nodename=jcr:content

    node.operation=not

    p.limit=-1

    But Still I am getting the list of pages which has jcr:content in it. My ultimate aim is to skip the jcr:content  from search results is there any way to that ?

    Translate
      arunpatidar
      Community Advisor
      arunpatidarCommunity Advisor
      Community Advisor
      June 8, 2018

      Hi,

      nodename doesn't support operation features only property does. So it won't work.

      In this case you need to write your own predicate like Child to achieve this

      OR you can create a servlet which traverse through path and find out all the Childs without jcr:content using Node API, and if you wish you can delete those nodes right away inside Servlet.

      Thanks

      Arun

      Translate
      Arun Patidar
        lucian_nicolaescu
        Level 2
        February 2, 2021

        You could use the groovy console (http://localhost:4502/groovyconsole) with a simple script like:

        final query = session.workspace.queryManager.createQuery("SELECT * FROM [cq:Page] AS page WHERE ISDESCENDANTNODE(page, '/content/yoursite')", "JCR-SQL2") final results = query.execute() results.nodes.each{ node -> if (!node.hasNode("jcr:content")) { println node.path + " is missing the jcr:content node" } }

         As you can see, this only searches for pages but can be changed or extended to work for dam:Asset depending on your use-case.

        Translate
          kautuk_sahni
          Adobe Employee
          kautuk_sahniAdobe Employee
          Adobe Employee
          February 3, 2021
          Thank you for sharing solution with community.
          Translate
          Kautuk Sahni
          basil
          December 16, 2022

          Old post but documenting it if someone stumbles across it:

          It may not be possible to check directly if a node has a jcr:content node, but in many cases it may suffice to check for a certain property, like jcr:title if you are search for "Pages without a jcr:content node", for example:

           

          SELECT * FROM [cq:Page] AS p WHERE ISDESCENDANTNODE([/content/mysite]) AND p.[jcr:content/jcr:title] IS NULL
          Translate
          arifuzzaman-chowdhury
          July 24, 2023

          I think the following query will work if the intention is to find the Pages.

          It basically checks if the child node, jcr:content, has the property, jcr:title.
          The assumption is - all jcr:content has jcr:title. If there is a jcr:content without this property, the query won't work.

           

          path=/content type=cq:Page property=jcr:content/jcr:title property.operation=exists property.value=false p.limit=-1

           

          Translate
          Terms & ConditionsAccessibility statement

          Loading footer...