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

[aemUser2345]

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'

[BrianKasingli]

Try this

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

[aemUser2345]

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

[Shiv_Prakash_Patel · Accepted solution]

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