How to query current node as well as its descendant nodes? | Community
Skip to main content
A
aemUser2345
New Participant
July 25, 2023
Solved

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

  • July 25, 2023
  • 2 replies
  • 928 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

 

2 replies

Shiv_Prakash_Patel
Shiv_Prakash_PatelAccepted solution
New Participant
July 26, 2023

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
    BrianKasingli
    BrianKasingli
    New Participant
    July 26, 2023

    Try this

     

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

     

      A
      aemUser2345Author
      New Participant
      July 26, 2023

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

        Terms & ConditionsAccessibility statement

        Loading footer...