Hello,
during my work with AEM 6.4 I've faced following situation:
In my Content repository exists a node which has subnodes. In example the node has the path "/content/sites/startnode". Underneath this node exists some children those have following properties:
- childenode A:
- childenode B:
- childnode C:
I wrote two different SQL-queries:
The resultset from first query contains childnode A and C. The resultset from second query contains only childnode C. My questions:
1st: Does '<>' compare values and types at same time? 2nd: How can I exclude some childnodes with avoiding the use of contains?
Solved! Go to Solution.
Hi,
You can try with not operand
SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE(s, '/content/sites/startnode') and NOT (s.number = '2')
Hi,
You can try with not operand
SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE(s, '/content/sites/startnode') and NOT (s.number = '2')