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

Forum|Forum|2 years ago
July 25, 2023
2 replies
933 views

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'

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Shiv_Prakash_Patel

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

BrianKasingli

Community Advisor and Adobe Champion

Try this

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

A

aemUser2345Author

Level 3

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

Shiv_Prakash_Patel

Accepted solution

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded