Is there way to know nodes without jcr:content node? | Community
Skip to main content
GK-007
GK-007
Level 9
December 9, 2016
Solved

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

  • December 9, 2016
  • 16 replies
  • 8601 views

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.
Best answer by kautuk_sahni

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

16 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

Arun Patidar
    V
    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 ?

      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

      Arun Patidar
        L
        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.

          kautuk_sahni
          Community Manager
          kautuk_sahniCommunity Manager
          Community Manager
          February 3, 2021
          Thank you for sharing solution with community.
          Kautuk Sahni
          B
          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
          A
          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

           

          Terms & ConditionsAccessibility statement

          Loading footer...