New Participant

Solved

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

Forum|Forum|9 years ago
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

A

arifuzzaman-chowdhury

New Participant

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

B

basil

New Participant

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

L

lucian_nicolaescu

New Participant

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

Employee

Thank you for sharing solution with community.

Kautuk Sahni

arunpatidar

New Participant

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

V

velpa

New Participant

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 ?