Expand my Community achievements bar.

Radically easy to access on brand approved content for distribution and omnichannel performant delivery. AEM Assets Content Hub and Dynamic Media with OpenAPI capabilities is now GA.
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