AEM Querybuilder - How to return only the folders under a path?

[ksuren]

I'm trying to rerun only the folders from a given path using query builder on AEM

Query:

path=/content/dam/we-retail/en 
type=sling:OrderedFolder 
p.hits=selective
p.nodedepth=1 
p.limit=-1 

Or URL

http://localhost:4502/bin/querybuilder.json?p.hits=selective&p.limit=-1&path=%2fcontent%2fdam%2fwe-r...

The query returns 35 records, while there are only 6 folders under /content/dam/we-retail/en. How can i return only these 6?

[smacdonald2008]

I tested this -- ocalhost:4502/libs/cq/search/content/querydebug.htm

I have 20 components under here:

Used this query and it returned the correct results..

[ksuren]

I'm looking to return folders and using "sling:OrderedFolder" or "sling"Folder", query returning sub-folders also. I wanted only top level under "/content/dam/we-retail/en"

[arunpatidar · Accepted solution]

Hi,

You use below query

type=nt:base

path=/content/dam/we-retail/en

property=jcr:primaryType

property.1_value=sling:OrderedFolder

property.2_value=sling:Folder

path.flat=true

p.hits=selective

p.properties=jcr:path

add more value for property like property.X_value if you want to include more types.

Thanks

Arun

[ksuren]

Works like a charm.. thanks arunp99088702​ , saved me a ton of time!