Silly Question - Query Builder to find published sites in a path

[RooRue]

Hi,

I'm new to... everything here and just wondering if someone could tell me how I can run a query to show me all the published pages down a path. I tried below but I'm not sure im doing it right:

path=/content/workplace-microsites
type=cq:page
property=cq:lastReplicationAction
property.value=Activate
p.limit=-1

Any help would be awesome.

[manjunathdj · Accepted solution]

@RooRue  - You can narrow query based on path/template 

property=@jcr:content/cq:lastReplicationAction
property.value=Activate

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/how-to-search-for-only-pag...

hopes help you.

Thanks,

Manjunath DJ

[SwetaB]

Hi @RooRue ,

If you want all pages under the path irrespective of the resourceType then your query is correct.

You can test in the query debug tool.

http://localhost:4502/libs/cq/search/content/querydebug.html

Also refer the below where you can find many use cases for querying

https://github.com/paulrohrbeck/aem-links/blob/master/querybuilder_cheatsheet.md

Hope this helps.