Expand my Community achievements bar.

Learn about Edge Delivery Services in upcoming GEM session
SOLVED

How to query current node as well as its descendant nodes?

Avatar

Level 3

Is there any way to query on the current node as well as its descendant nodes based on the below query? I also want to check whether the current node has [jcr:content/cq:lastReplicationAction] = 'Activate'

SELECT DISTINCT page.[jcr:path] FROM [cq:Page] AS page WHERE ISDESCENDANTNODE(page, '/content/') AND page.[jcr:content/cq:lastReplicationAction] = 'Activate'

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @aemUser2345,

You can try SQL2 query as suggested by @BrianKasingli .

If you want to use QueryBuilder, Please try this.

path=/content/
type=cq:Page
property=jcr:content/cq:lastReplicationAction
property.value=Activate
path.self=true
p.limit=-1

Regards,

Shiv

 

Shiv Prakash

View solution in original post

3 Replies

Avatar

Community Advisor

Try this

 

SELECT page.[jcr:path] FROM [nt:base] AS page
WHERE ISDESCENDANTNODE(page, '/content/')
AND page.[jcr:content/cq:lastReplicationAction] = 'Activate'

 

Avatar

Level 3

sorry for this query I am still getting the descendant nodes, and unable to get the current node.

Avatar

Correct answer by
Community Advisor

Hi @aemUser2345,

You can try SQL2 query as suggested by @BrianKasingli .

If you want to use QueryBuilder, Please try this.

path=/content/
type=cq:Page
property=jcr:content/cq:lastReplicationAction
property.value=Activate
path.self=true
p.limit=-1

Regards,

Shiv

 

Shiv Prakash