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

Question

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'

Shiv_Prakash_Patel · Accepted Answer

Hi @aemuser2345,You can try SQL2 query as suggested by @briankasingli .If you want to use QueryBuilder, Please try this.path=/content/type=cq:Pageproperty=jcr:content/cq:lastReplicationActionproperty.value=Activatepath.self=truep.limit=-1Regards,Shiv

BrianKasingli · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO