What JCR query can I use to find nodes which don't have a child node which name is 'XXXX'?

[yasuoo]

I want to find nodes which DON'T have a child node which name is 'XXXX' in CRXDE Lite, Query Tool.  What Xpath or SQL2 queries archive my goal?

- yasuo

[smacdonald2008 · Accepted solution]

Here is a stackover flow thread for JCR query that may help -- you can get an idea of how use child nodes (in your case - exclude them). 

http://stackoverflow.com/questions/15137322/jcr-sql2-fulltext-search-in-node-properties-and-all-chil...

[yasuoo]

Specifying "nodes which has a child node which name is "xxx" is easy,  but specifying "nodes which does not have a child node which name is "xxx" is hard for me.