How to find nodes without specific child node?

[Alex_Popov1]

Hello,

Can someone help me with query in CQ?
How can I find nodes without specific child node (e.g. jcr:content)?

Thanks.

[Paul_McMahon]

I am not sure I understand the question. Can you expand on your use case, what kind of nodes are you searching for - components within a page? 

[Alex_Popov1]

I have nodes under /content/myapp/en:

/content/myapp/en/jcr:content
/content/myapp/en/item
/content/myapp/en/item/jcr:content
/content/myapp/en/item2
/content/myapp/en/item2/jcr:content
/content/myapp/en/item3
/content/myapp/en/item4

I want to write xpath query to find nodes without jcr:content.
As result I want to see:
/content/myapp/en/item3
/content/myapp/en/item4

[smacdonald2008]

Why not use JCR-SQL? 

[Sham_HC · Accepted solution]

You cant do with xpath. Refer [1] published just now to find page that are missing jcr:content.

[1]   http://aemfaq.blogspot.com/2013/12/how-to-find-missing-content-nodes-in.html

[Alex_Popov1]

It doesn't matter. Could you show please, how to do it using JCR-SQL?

[findbtcatmnearme]

It is similar to the bitcoin ATM, but it does many things beyond the regular crypto ATMs. This kiosk lets the users purchase and sell the cryptocurrency of their choice straight on the machine with cash. You can consider the ATM as the currency exchange kiosk. It renders ultimate power and flexibility to go from fiat to digital currency and vice versa. As said earlier, Coin Cloud Bitcoin ATM is one of the majorly used cryptocurrency ATMs for buying and selling bitcoin.