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'
Solved! Go to Solution.
Views
Replies
Total Likes
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
Try this
SELECT page.[jcr:path] FROM [nt:base] AS page
WHERE ISDESCENDANTNODE(page, '/content/')
AND page.[jcr:content/cq:lastReplicationAction] = 'Activate'
sorry for this query I am still getting the descendant nodes, and unable to get the current node.
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
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies