Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

How to generate and download a report of the asset tagged under a specific tag category?

Avatar

Level 3

How to generate and download a report of the asset tagged under a specif tag category?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

you can write a servlet which executes a query with the above condition and put results in CSV or in Other Formats.

The query can look like below for searching Assets which tags either with we-retail:apparel/footwear or we-retail:apparel/shorts

QueryBuilder Query

type=dam:Asset

path=/content/dam

property=jcr:content/metadata/cq:tags

property.1_value=we-retail:apparel/footwear

property.2_value=we-retail:apparel/shorts

p.hits=selective

p.properties=jcr:path

p.limit=-1

The bold part from the query can be removed. That is for json output from QueryBuilder Debugger Tool to only gives assets path.

Or create your own reporting by following below:

Developing Reports

View solution in original post

0 Replies

Avatar

Correct answer by
Community Advisor

you can write a servlet which executes a query with the above condition and put results in CSV or in Other Formats.

The query can look like below for searching Assets which tags either with we-retail:apparel/footwear or we-retail:apparel/shorts

QueryBuilder Query

type=dam:Asset

path=/content/dam

property=jcr:content/metadata/cq:tags

property.1_value=we-retail:apparel/footwear

property.2_value=we-retail:apparel/shorts

p.hits=selective

p.properties=jcr:path

p.limit=-1

The bold part from the query can be removed. That is for json output from QueryBuilder Debugger Tool to only gives assets path.

Or create your own reporting by following below:

Developing Reports

Avatar

Level 3

Thanks Arun, will test and get back to you.