Skip to main content
prachimathur
Level 2
Mar 13, 2025 8:45 AM UTC
Solved

Download asset report

Hi, I'm trying to download asset report in csv file from ACS AEM Commons using query builder but I'm getting an empty excel with no assets. Below I mentioned my query-

type=dam:Asset
path=/content/dam/cognizant-dot-com
group.1_daterange.property=jcr:content/jcr:lastModified
group.1_daterange.lowerBound=2025-03-01
group.1_daterange.upperBound=2025-03-15
p.limit=1000
p.guessTotal=true
p.indexTag=assetsOmnisearch

 

giuseppebaglio
giuseppebaglioAccepted solution
Level 10
Mar 13, 2025 9:05 AM UTC

I believe the issue may lie in the "Result Columns" section. At a minimum, you must add the component "ACS Commons Report Builder Path Column" to view the asset paths. This is my configuration, which is quite simple:

 

 

 

 

 

 

It gives the following result:

 
View in thread

3 replies

giuseppebaglio
giuseppebaglioAccepted solution
Level 10
Mar 13, 2025 9:05 AM UTC

I believe the issue may lie in the "Result Columns" section. At a minimum, you must add the component "ACS Commons Report Builder Path Column" to view the asset paths. This is my configuration, which is quite simple:

 

 

 

 

 

 

It gives the following result:

 
Translate
    prachimathurAuthor
    Level 2
    Mar 13, 2025 11:58 AM UTC

    This is working. Thanku

    Translate
    Karishma_begumSh
    Karishma_begumSh
    Level 4
    Mar 13, 2025 9:33 AM UTC

    hi @prachimathur 

    once try to rewrite the query as below before ACS AEM commons

    type=dam:Asset
    path=/content/dam/cognizant-dot-com
    group.1_daterange.property=jcr:content/jcr:lastModified
    group.1_daterange.lowerBound=2025-03-01T00:00:00.000Z
    group.1_daterange.upperBound=2025-03-15T23:59:59.999Z
    orderby=@jcr:content/jcr:lastModified
    orderby.sort=desc
    p.limit=-1

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...